Power Bi - Enterprise Edition

Power Bi - Enterprise Edition

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.

App Registration - Guide & Required scopes:

How to create an App Registration: https://learn.microsoft.com/en-us/entra/identity-platform/quickstart-register-app

  • Power BI Service:

    • Dataset.Read.All

    • Report.Read.All

    • Workspace.Read.All



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.


7. 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.



8. 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:
The Report ID you will find after the /reports/, so in this case our Report ID is:
Quote
a0169bf5-c6d6-4b8b-8afe-cfba638d744b/2d4406d49bd9acade258

The Workspace ID you will find in between the /groups/ and the /reports/, so in this case our Workspace ID is:
Quote
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 menuEmbed 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.



    • Related Articles

    • How to show a Microsoft Power BI report in Q-Play V2

      Introduction This guide will help you set up an integration between Microsoft Power BI and Q-Play, as well as upload your reports directly to the Q-Play Power BI app. By following this guide, you’ll learn how to connect Power BI with Q-Play and how ...
    • How to Display Grafana Reports in Q-Play

      Introduction With the Grafana integration in Q-Play, you can easily display your Grafana dashboards directly on your screens. This allows you to present real-time data from your preferred data sources in a visually appealing way. In this guide, we ...
    • Setup Guide for IOT DIN Relay 1 Phase with WIFI

      This guide will assist you in securely and effectively connecting your IOT DIN Relay 1 Phase via WIFI. Please follow these steps carefully to ensure a successful setup. Recommended Network Connection: It is strongly recommended to use a LAN network ...
    • How to use on/off screen (Black screen)

      Introduction This guide will show you how to easily activate the power on/off function for your screens in the app. With this feature, you can set a schedule for when your screens will automatically turn on and off. This is a convenient way to ensure ...
    • How to Connect an IoT Product to Q-Play

      This guide explains how to connect an IoT product to Q-Play. Once the device is connected, the IoT product will turn off in the same cycle as the player. Note: This feature is only available in Q-Play V2. Contact support if you are unsure which ...