PingCastlePowerBIConnector

PowerBI Connector for PingCastle Enterprise

How to use it

Installation

1. Copy the extension file into the [Documents]\Power BI Desktop\Custom Connectors directory

Note: if this directory doesn't exist, you have to create it

2. Open Power BI Desktop

Note, to load extensions without allowlisting the extension, you will need to lower the security level for extensions in Power BI Desktop to enable loading unsigned/uncertified connectors. See below.

3. Go to File | Options and settings | Options

4. Go the Security tab
5. Under Data Extensions, select Allow any extension to load without warning or validation

6. Restart Power BI Desktop

How to connect

1. Select Get Data

2. Select Source

Enter here the PingCastle Enterprise server FQDN

3. From PingCastle Enterprise, select an API key which has the right to read data (upload reports is not ok)

4. Copy paste the API key into the PowerBI screen

5. You will then be able to see the PingCastle Enterprise data

Troubleshooting

Invalid FQDN

If the FQDN is invalid, the connector will fail at the preview phase.

The solution is to connect again with the right FQDN.

Invalid Key

If the key is invalid, the connector will fail at the preview phase.

Sometimes, the credential is cached and is not asked again. The solution is to clear it.

Go to Data source settings.

Edit the credential.

And delete it.

Reference documentation for the plugin

https://learn.microsoft.com/en-us/power-query/