Step 1 - Configure the Trovata Developer Portal Application that will have access to all of the end points you would like to pull into Microsoft PowerBI.
Step 2 - Record the app information
Step 3 - Go to docs.trovata.io to review and decide which endpoints you’d like to configure to PowerBI. Enter the appid, secret, companyid to configure the specific endpoint.
Step 4 - Go to powerBi and select Get Data from Web open the advanced setting. Enter the url of the configured endpoint query which can be lifted from docs.trovata.io. In the advanced fields you will enter 3 custom parameters in the added fields:
appid: appid
secret: secret
companyid: companyid