Perspio.mez custom connector file

1. Download the Power BI Custom Connector file here.
2. Rename the file to Perspio.mez after downloading.

Pre - Requisites

1. Power BI Desktop should be installed.
2. Launch Power BI Desktop.
3. Go to File > Options and Settings > Options.

4. Then select Security, and in the Data Extensions section enable the (Not Recommended) Allow any extension to load without validation or warning option, and click OK.

5. Login to Perspio and navigate to Admin > API > Add Application

3. Give it a suitable name and then click create

4. Note down App Id, App Secret, and App Secret Id
   • App Id = clientId
   • App Secret = clientSecret

5. Click on Go to api and then click on Show Subscription Key. Note this subscription key.

6. So, at the end of this you need to have clientId (App Id), clientSecret (App Secret) and SubscriptionKey (Subscription Key)

Steps to host and consume Perspio Power BI Custom Connector

1. Place the Perspio.mez file in the following folders and restart Power BI Desktop to access this Custom Connector

   %USERPROFILE%\Documents\Microsoft Power BI Desktop\Custom Connectors

2. Restart Power BI Desktop if it is already open.

3. Select Get Data

4. Select GetAssets to get Asset Data and click on Connect

5. Provide SubscriptionKey, TenantId, Client Id and Client Secret values to authenticate with the Get Assets Api call behind the scenes and click ok

6. After you click ok, you will get the assets data from the perspio api. Just click Load

7. Once it loads you should be able to see the data

8. Repeat the steps 5 - 8 to choose Devices data

Troubleshooting Steps

If and only if Power BI is installed for the first time and you have not worked on any other reports using Power BI then you could clear the cache in the following locations and try.

If you have worked on other reports using Power BI, clearing the cache could erase your work history. So, you need to be very cautious while attempting this one.

1. Once Power BI Desktop is installed, ensure that the following folders are clean %LOCALAPPDATA%\Microsoft\Power BI Desktop\Cache (Clear this Cache)

%USERPROFILE%\Documents\Power BI Desktop

%USERPROFILE%\AppData\Local\Microsoft\Power BI Desktop\Custom Connectors

%USERPROFILE%\AppData\Local\Microsoft\Power BI Desktop\Cache

C:\Users\Public\Documents\Power BI Desktop\Custom Connectors