What do you gain by switching to Power Bi Enterprise?

With the new Power Bi Enterprise, we got rid of the whole "service user without MFA". It is now possible to authorize login using a Microsoft account, or your own custom app registration. This means higher security, ease of use and more stability, as we are using Microsoft’s recommended integration with Power Bi.

A new feature of the Power Bi Enterprise app, is that you can now run live dashboards, as part of a report as well as screenshots of your reports. Disclaimer: LG doesn’t support live rendering, so only screenshots work on LG monitors.

Areas of attention:

1. The Power Bi integration only works with reports that are in your shared workspace, private or your own workspace won’t work, as they are restricted to your own Microsoft account.
   
   
   
2. The user that authorizes the Microsoft authentication in the Power Bi integration, has to be using a Power Bi Pro license. If you’re using a custom app registration, you need to assign Power Bi Pro access to this.
   
   
3. The Power Bi Enterprise integration only works with screenshots, in the app, in the designtool, you can choose whether you want live dashboard or screenshot of reports.
   
   
4. If you are not using PowerBi Premium in your workspace, this message will appear in the PowerBi Enterprise integration, this will also appear on all your reports and dashboards in Q-Play. To remove this, you need to buy Power BI Embedded (A SKU) depending on your use case.
   
   
   
5. Right now you are only able to show 1 report per script, if you wanna show multiple pages, they have to be in their own separate report.
   

App Registration - Guide & Required scopes

1. Power BI Service permissions needed:
   
1. Dataset.Read.All
   
2. Report.Read.All
   
3. Workspace.Read.All
   

1. Sign in to Power BI with an account that has Power BI Admin privileges.
   
2. Click the gear icon (⚙️) in the top-right corner.
   
3. Select Admin portal from the dropdown menu.
   

1. Allow service principals to use Power BI APIs.
   
1. Purpose: Enables Azure AD app registrations (service principals) to authenticate and interact with Power BI via REST APIs.
   
2. Recommended Configuration:
   
1. Enabled.
   
2. Scope: Entire organization or specific security groups.
   
   
2. Allow API access to reports and datasets.
   
1. Purpose: Controls whether applications can read reports and datasets using the Power BI REST API.
   
2. Recommended Configuration:
   
1. Enabled.
   
2. Scope: Entire organization or specific security groups.
   
   
3. Embed content in apps.
   
1. Purpose: Required for embedding Power BI content in custom applications using the REST API or JavaScript SDK.
2. Recommended Configuration:
1. Enabled.
2. Scope: Entire organization or specific embedding apps.
   
   
4. Export data.
   
1. Purpose: Determines whether users and applications can export data from reports.
2. Note: This does not restrict semantic model querying via API.
3. Recommended Configuration:
1. Enabled if data export is required.
2. Scoped to trusted users or apps.

Setting up the integration

1. On the left side menu, choose the Integration option.

2. Find the Power Bi Enterprise, and press the Configure button, to start the setup. Make sure its the Power BI Enterprise version.

3.Choose whether you want to run with Authorize with Microsoft or your own App Registration. Then click on Save.

4. The integration will then take you to the next step, but first you need to either authorize with your Microsoft account, or set up your app registration. To do so, press the Settings button.

5. It will then take you back to the settings, where you either press the Authorize button, and allow your Microsoft account to login, or if you choose to use the app registration fill in the field on the page. When finished, remember to press the Save button at the bottom of the screen.

6. When done with authorization, our service user with the name Q-Play PowerBi Integration will now be available, you then need to give it access to your shared workspace, otherwise the integration won’t work.

Setting up the scripts

1. If you want to use static screenshots of your work, you then need to create a report in the integration of each specific work you want to show. Do this by going to settings, then pressing the + in the green bar in the middle of the screen.

2. Then in the Script dropdown menu, choose Report, now give your report a descriptive name so you can easily remember what that report is about. You will then need the Report ID and Workspace ID, to find these, all you need is your URL to the report.

Example of how to find your Report ID and Workspace ID from your URL.

Our sample URL will look like this:

https://app.powerbi.com/groups/a9351ad7-83a7-47be-b4a2-fe425a8c5c25/reports/a0169bf5-c6d6-4b8b-8afe-cfba638d744b/2d4406d49bd9acade258?experience=power-bi

The Report ID you will find after the /reports/ and up to the first /, so in this case our Report ID is:

a0169bf5-c6d6-4b8b-8afe-cfba638d744b

The Workspace ID you will find in between the /groups/ and the /reports/, so in this case our Workspace ID is:

a9351ad7-83a7-47be-b4a2-fe425a8c5c25

If this report is only going to be screenshots, then press the Enable screenshot functionality box.

You then need to choose your schedule type, you have two options:

1. On-demand;
1. This option is best suited if you want to show more than just this one report, in the same presentation. This option means that every time the presentation shows this report, the screenshot will get updated – within the Resource timeout limit. With a standard subscription, you can choose between 1 hour and 30 min. If you need a faster update time, please contact us to get the options unlocked.
2. Scheduled;
   
1. This option is best suited if you only want to show this one report, in your entire presentation. This option means that the integration will refresh the screenshot at a set time interval – with a standard subscription, you can choose 1 hour. If you need a faster update time, please contact us to get the options unlocked.

---

Setting up the presentation in the designtool

1. In a new page in your presentation, find the Power Bi Enterprise app, then press it to get an instance of it. Make sure you select the Enterprise version of the app, and not the standard version – otherwise your new Enterprise integration won’t work.

2. In the Template settings, choose whether you want Live – dashboard, or Screenshot – report.

3. Then choose which report or dashboard you want to show, by choosing in the dropdown menu – Embed is for live dashboard, Screenshot is for static reports.

4. You can then customize the app to your liking in the App Settings, and your new Power Bi Enterprise is all set up!

---

FAQ:

Q: I’m getting a 401-error when trying to run the script.

A: Make sure that the user who authorized with Microsoft, has a Power Bi Pro license, otherwise you will get the 401-error. Also, make sure that the Q-Play PowerBI Integration service user has access to the correct shared workspace.