Create some data in Repods
Repods allows you to create analysis extracts from your core data model in the Analysis panel. Here you can create a Report using the built-in OLAP drill tool.
You can also create Workbooks to create individual result extracts with custom SQL.
If you have already prepared some results tables as shown above, you can now create an Access Key to grant PowerBI access rights to these reports.
Set up Repods access
To access data in Repods, you have to explicitly allow this from within the platform. You do this by creating access keys and assigning individual access rights on selected reports or workbook cards to this access key.
Open the WEB API Tool, create a new Access Key, and check all the reports or/and workbook cards for which you want to allow PowerBI read access.
Hit Save and these Reports and Workbook Cards result tables will be accessible via our API using the created access key.
You can also use this access key to access the data with any REST Request. So you can also use the data in your custom web, mobile app, or any other service. Check out our API documentation here.
Set up PowerBI for import
PowerBI gives you many options to import data. We will use the web import here.
First, create a new Web Import in the Get Data menu:
Second, enter the REST Endpoint of the Repods table in the following menu:
You can obtain the URL to use here by clicking the little clipboard icon next to a report/workbook card in the Repods WebAPI settings.
So far, you have not entered the access key, so Repods responds with an empty JSON on the report request. To enter the credentials, click OK on all the following panels. Now go to the Edit Queries menu and go to Data source settings.
Here you mark the URL you have just added and click the permissions button at the bottom.
Then you choose Credentials Type Basic. To start using PowerBI, simply add the access key from the Repods WebAPI panel to the user name input form. Leave the password blank.
Now the connection is set up and you can refresh this query. After that, you need to help PowerBI to interpret the JSON response that Repods delivers by default. You can also change this to a csv type response using the switches in the Repods API.
Typically, you first convert the response into a table in the PowerBI Query editor, then you Expand the columns and change the datatypes.
You are all set now! Using PowerBI, you can start creating dashboards based on the data from your Repods data pod. Take a look at our example:
Subscribe to our blog!
Stay up to date with the latest data science and IoT tips and news.