Skip to main content
All CollectionsDeveloper Portal
How to pull Trovata data into Microsoft PowerBI
How to pull Trovata data into Microsoft PowerBI

An automated way to get data from Trovata.io to Microsoft's PowerBI

Chris Brown avatar
Written by Chris Brown
Updated over 2 months ago

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

Did this answer your question?