Adding a PowerBI Report

Power BI is a powerful data visualisation tool that is fully integrated into the Content Catalyst platform

It is easy to pull through data and analysis from PowerBI into your Content Catalyst system.

To publish a "public" PowerBI report or dashboard, you can do this in the same way as other content not hosted on your Content Catalyst site via our External Report feature, using the parameters supplied in the share link. 

However publishing a "private" PowerBI report or dashboard would result in the end user being prompted to authenticate, requiring them to log in with a Microsoft account, have suitable access to the correct PowerBI tenant, and would require them to have a PowerBI Pro license.

Embedding a "private" PowerBI report

To do this, you will need to create reports in PowerBI but your users will conveniently be able to access your content through the Content Catalyst platform.

1) First, create a new External Report in the system, with metadata, by following the steps here.

2) Once you have created the External Report placeholder, you need to edit the External Report Settings – available from the Related Actions menu on for the report.

3) Add the External report properties listed below:

• Log-in page URL – the text displayed on the user link
• Actual login URL – this should be set to [powerbiurl]
• Request type – this needs to be GET
• Automatic form submission – we recommend Auto (iframe in page, hide report tabs)
  
  

4) Next you need to add parameters to this report to tell your Content Catalyst system exactly what to open:

Select Add new parameter and input the code of your PowerBI Workspace.

Then do the same for the specific report you want to display, your PowerBI Report.

You can find this information in the URL of your chosen report on PowerBI

5) Once you save these details and provide a license, users will be able to view, filter and explore your PowerBI report alongside your other content in Content Catalyst.