All Collections
Integrations
Power BI
Connect Power BI to Simplesat API
Connect Power BI to Simplesat API

How to get Simplesat answers directly into Power BI

Hannah Logan avatar
Written by Hannah Logan
Updated over a week ago

You will need:

  • A copy of the Simplesat Data Connector PBIX file (download here)

  • An account token

To get your Simplesat token, go to Account Settings > Account Key:

Note: Only users with Owner or Admin role can view the Account Key.


Connect to Power BI (desktop):

Add file to desktop app:

  • Go to File > Open report > Browse reports to get the PBIX file from the File Explorer, and it will be added to the report you are currently working on

Sync the data from your Simplesat account:

  • Go to Options and Settings > Data source settings

  • Click on Edit on the Edit Permissions pop-up

  • On the next pop-up, choose Web API, add your account key from Account settings page on Simplesat, and then click on Save

  • Click OK on the Edit permissions pop-up, and then Close on the data source settings pop-up, and you should be able to use your feedback data from Simplesat on Power BI


Connect to Power BI (cloud):

Add file to cloud app:

  • Head over to your Power BI account and go to My workspace

  • Click on Upload > Browse, then upload the PBIX file

Sync the data from your Simplesat account:

  • Hover to the left of the newly uploaded dataset to see a ... button, click on that then select Settings

  • In the Settings page, expand the Parameters section where you can add your Simplesat token, and then click on the Apply button


Once the token has been added, you can refresh the data to pull in your feedback data from your account and can schedule refreshes to make sure the data is always recent.
โ€‹

Note: This may take a while to pull in all of your Simplesat data from the API.

Can't get it to work? Send us a message and we'll help you out!๐Ÿ˜ƒ


โ€‹

Did this answer your question?