Power Bi - Enterprise Edition

Power Bi - Enterprise Edition

What's new in Power Bi Enterprise v1.1.0?

  1. Added support for Dashboards.
  2. Added page selection for reports:
    1. If embedded page selection is within the app.
    2. If screenshots page selection is within the integration.
  3. Added ability to hide pagination and filter tab for embedded reports in the app.
Are you already using Power Bi Enterprise 1.0.0?
You can easliy upgrade to version 1.1.0, by simply pressing the "upgrade" button on the right hand side of the integration. Be aware that new permissions is required for the usage of Dashboards, therefor a new authorization is needed for version 1.1.0 to work!

Areas of attention:

  1. The Power Bi integration only works with reports and dashboards that are in a shared workspace! Private, or your own workspace, won’t work, as they are restricted to your own Microsoft account.

  2. Embedded reports and dashboards isnt supported by older SoC players, like LG, Samsung, Sony and so on. These usually isnt powerful enough to run the embed, we therefor dont offer support when using embedded on SoC players.

  3. The user that authorizes the Microsoft authentication in the Power Bi integration, has to be using a Power Bi Pro license, and be an administrator within your Microsoft organisation.

  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 embeds in Q-Play. To remove this, you need to buy Power BI Embedded (A SKU) depending on your use case.

Custom App Registration - Guide & Required scopes

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

You also need to grant the tenant acces to the PowerBi API and reports, this is done by doing the following:

Accessing the Admin Portal:
  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.

Navigating to Tenant Settings:
  1. In the Admin Portal, select Tenant settings from the left-hand menu.
  2. The page displays a categorized list of all configurable tenant-level features.

Key API-Related Settings to Review:
  1. Allow "Service Principals can call Fabric public 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 "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.

Setting up the integration

  1. In Q-Play, in the left side menu, go to the Integrations page.
  2. Click on the "New integration" button on the right side of the screen.
  3. Find the Power Bi Enterprise, and press the Configure button, to start the setup.
  4. Give it a fitting name, and choose whether you want to run with Authorize with Microsoft or your own App Registration. Then click on Save before continuing.
  5. The integration will then take you to the "Integration status" tab, but first you need to go back to the integration settings and either authorize with your Microsoft administrator account, or set up your app registration. When finished with the authorization, remember to press the Save button at the bottom of the screen.
    1. When using "Authorization with Microsoft", a service principal user named "Q-Play PowerBi v1.1" will be created in your Power BI. You need to give this serviceprincipal access to the shared workspace, from which reports or dashboards will be displayed, and assign the necessary permission level in the workspace. The minimum required permission level is "Member".

Setting up the scripts

  1. In the "Settings" tab, press on the "+" in the bottom of the screen, this will allow you to set up a script to show your Power Bi.
  2. Choose what type of Power Bi data you want to display, either embedded reports, embedded Dashboard, report screenshot or dashboard screenshot.
    1. Embed report, and embed dashboard, is a live view of the report or dashboard, therefor the integration only needs the workspace ID and report or dashboard ID.
  3. To find the IDs of the report or dashboard, this is done the following way:

Example of how to find your workspace ID, report/dashboard ID and the page ID.

Our sample URL looks like this:
https://app.powerbi.com/groups/a9351ad7-83a7-47be-b4a2-fe425a8c5c25/reports/17ede4fe-c333-436f-8dd4-603076ed61fd/d316d4890f4f3f1dac7e?experience=power-bi
The workspace ID is found after the "groups/" tag, so in this case its: a9351ad7-83a7-47be-b4a2-fe425a8c5c25
The report/dashboard ID is found after the "reports/(or)dashboards/" tag, so in this case its: 17ede4fe-c333-436f-8dd4-603076ed61fd
The page ID is only needed when using screenshots of reports, its found after the report IDs middel backslash, so in this case the page ID is: d316d4890f4f3f1dac7e

For the screenshots you also need to choose your schedule type, you have two options:
  1. On-demand;
    1. This options is best suited if your presentation consists of more then 1 slide. On-demand means, that when the slide with the Power Bi app is being shown, the integration will refresh. If the slide is never actively shown, the integration will never refresh. 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 presentation (designtool), or playlist, find the Power Bi Enterprise app, then press it to get an instance of it.
  2. In the Template dropdown, choose what you want to display:
    1. Power Bi - Embedded Report.
    2. Power Bi - Screenshot Report.
    3. Power Bi - Embedded Dashboard.
    4. Power Bi - Screenshot Dashboard.
  3. Then in the Data sources tab, find the integration you have set up, and choose the script you want to show. If you only have 1 Power Bi integration set up, the app will auto select this integration, the same goes for the script.
  4. Under Template settings, you have different options for how you want the report or dashboard to be displayed (Please note that a dashboard is not dynamic, and there is therefore a chance that it will not fit perfectly on the screen. This is not something Q-Play can change, but a standard defined by Microsoft.):
    1. When using a report, you can select which page you want to show. You can also hide the page navigation and the filter selection.
    2. When using a dashboard, you can choose what fitment the dashboard should have.

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.


Q: I'm getting a 403-error when trying to run the script.

A: This error means: "The page exists, but there missing permissions to look at the page" Make sure that the Q-Play Integration service-user have admin rights to the workspace, if not, it is missing permissions to view the repport.


Q: I'm getting a 404-error when trying to run the script.

A: This error means: "The page does not exist". This can be caused by multiple issues. If the script log is very short, make sure to press the "save" button after you have authrorized with Microsoft. If there is no ID between the ...microsoftonline.com/ and the /oauth2... Then the autorization isnt saved.
If there is an ID, and the error is coming in later, make sure that the workspace and report ID is correct, also make sure that the report is in a shared workspace, and not your own private workspace.





    • Related Articles

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

    • SharePoint Docs - Show Your PowerPoint, Word and Excel SharePoint Documents In Q-Play

      Introduction This guide will show you how to integrate an Excel file stored in Microsoft SharePoint into Q-Play, so you can pull data directly from the Excel file into your presentation and display it on a screen. The guide is divided into two main ...

    • General Video Guide

      Below you'll find an installation and usage guide for optimizing and playing videos through various types of players, including external and built-in options. This guide includes recommendations for video sizes, using the conversion tool HandBrake, ...

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