power-bi-dashboard-to-integrate-into-repods

Using PowerBI on Top of the Repods Cloud Data Science Platform

This tutorial provides a quick overview of ways of using PowerBI, the Business Intelligence Dashboard, on your data prepared and maintained in the Repods Data Science Platform.

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.

reports dashboard in repods

You can also create Workbooks to create individual result extracts with custom SQL.

workbook card in repods

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.

setting up repods access for powerBI

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:

setting up powerBI for import

Second, enter the REST Endpoint of the Repods table in the following menu:

menu for the import

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.

data source settings panel

Here you mark the URL you have just added and click the permissions button at the bottom.

edit permissions in data source settings

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.

query editor in powerBI

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:

dashboard in powerBI created with data from repods

Subscribe to our blog!
Stay up to date with the latest data science and IoT tips and news.