Skip to content

Latest commit

 

History

History
83 lines (46 loc) · 2.35 KB

README.md

File metadata and controls

83 lines (46 loc) · 2.35 KB
Raw

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 folder

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

  1. 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.

  1. Go to File | Options and settings | Options

optionsandsettings

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

enablecustomextensions

  1. Restart Power BI Desktop

How to connect

  1. Select Get Data

main

  1. Select Source

Enter here the PingCastle Enterprise server FQDN

setupsource

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

agentkey

  1. Copy paste the API key into the PowerBI screen

insertkey

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

navigator

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.

invalidurl

Invalid Key

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

invalidkey

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

Go to Data source settings.

clearcredential1

Edit the credential.

clearcredential2

And delete it.

clearcredential3

Reference documentation for the plugin

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