WvdS Doku - en:int:dbgway:anwender:sicherheit https://www.wvds.it/wiki/ 2026-05-22T16:46:48+00:00 WvdS Doku https://www.wvds.it/wiki/ https://www.wvds.it/wiki/lib/exe/fetch.php?media=wiki:dokuwiki.svg text/html 2026-01-29T23:25:14+00:00 Anonymous (anonymous@undisclosed.example.com) 5.2 Excel with Certificate https://www.wvds.it/wiki/doku.php?id=en:int:dbgway:anwender:sicherheit:excel-mit-zertifikat&rev=1769729114&do=diff 5.2 Excel with Certificate OData connection with certificate authentication. Prerequisite * Certificate installed in Windows certificate store Establish Connection * Data -> Get Data -> From OData Feed * Enter URL: <https://gateway.company.com/odata/erp> * When prompted for certificate: Select your certificate text/html 2026-01-29T23:25:42+00:00 Anonymous (anonymous@undisclosed.example.com) 5.4 Common Problems https://www.wvds.it/wiki/doku.php?id=en:int:dbgway:anwender:sicherheit:haeufige-probleme&rev=1769729142&do=diff 5.4 Common Problems Solutions for typical certificate issues. "No Certificate Found" Cause: Certificate not installed or expired. Solution: * Check certificate in certificate store * Check validity (expiration date) * If expired: Request new certificate from IT text/html 2026-01-29T23:25:20+00:00 Anonymous (anonymous@undisclosed.example.com) 5.3 Power BI with Certificate https://www.wvds.it/wiki/doku.php?id=en:int:dbgway:anwender:sicherheit:powerbi-mit-zertifikat&rev=1769729120&do=diff 5.3 Power BI with Certificate Secure connection in Power BI Desktop. Set Up Connection * Get Data -> OData Feed * URL: <https://gateway.company.com/odata/erp> * OK Authentication In the authentication dialog: * Select Windows (uses your installed certificate) * Or: Organizational Account text/html 2026-01-29T23:24:44+00:00 Anonymous (anonymous@undisclosed.example.com) 5. Security https://www.wvds.it/wiki/doku.php?id=en:int:dbgway:anwender:sicherheit:start&rev=1769729084&do=diff 5. Security text/html 2026-01-29T23:24:50+00:00 Anonymous (anonymous@undisclosed.example.com) 5.1 Using Your Certificate https://www.wvds.it/wiki/doku.php?id=en:int:dbgway:anwender:sicherheit:zertifikat-nutzen&rev=1769729090&do=diff 5.1 Using Your Certificate How to use your personal certificate for data access. What is a Certificate? A digital ID that identifies you to the server. Like an electronic ID card. Technical background: Post-Quantum Cryptography Obtaining a Certificate * Contact IT department