Carousel Cloud can now securely integrate with Power BI so you can display reports live on your digital signage!
In this document, you will learn how to set up your Power BI integration using a service principal in Azure AD (required). This will then allow you to display reports you have given permission to the service principal access to. You can grant access to multiple workspaces and reports using a single service principal. See your Azure AD administrator for details.
The ability to use Power BI in this way requires embed tokens. Depending on your Power BI and Azure subscription type, you may have a trial amount to use but they will eventually run out unless you Create a Power BI Embed Capacity or a Power BI Premium Capacity. Please see to your Power BI administrator for details.
Authenticating Carousel with Power BI
Setup Azure AD
To set up an External Authentication for Carousel and Power BI you need to register Carousel as an Application and create a service principal in Azure AD. Then get these three pieces of information from it:
Certificate auth not supported at this time
To get started use this article to create a service principal in Azure AD. You must have adequate access, please see your admin for details.
Once you have created it, follow article sections, “Get tenant and app ID values for signing in” and, “Option 2: Create a new application secret” to obtain the information required for your Carousel External Authentication.
Setup Power BI
Now that you have a service principal you will need to give it API access to your Tenant. You will need to follow Step 6 of this article to allow Carousel to access the Power BI API.
You will now need to give the service principal permission to access the Power BI Workspaces that you would like to display reports from. Select Access in your Power BI workspace.
Then search for your service principal and give it access. Repeat this process for all workspaces you would like Carousel to have access to.
Please note: It takes some time for Power BI to register the service principal so please allow a few minutes after creating/editing one before authenticating with Carousel.
Setup External Authentication
In the Carousel UI, click on your username in the upper right, then select Configure, then select System.
There you will select External Authentications on the left-hand side and create a New Authentication.
There you will give your Authentication a name. This name will display when creating a Power BI Bulletin. Then you will enter the Tenant ID, Client ID, and Client Secret that you have gotten from the above Microsoft KB.
Now all you need to do is Save your new External Authentication and you will be able to use it to create Power BI bulletins in Carousel!
Power BI Bulletin Creation
To create a Power BI bulletin, navigate to the zone you would like it to display in and select New Bulletin, select Dynamic as the type, then select Power BI.
Select the Authentication you just created from the drop-down menu. The Workspace and Report drop-down menus will contain all of the workspaces and reports that you have given Carousel access to using your service principal. If those menus are empty, you will need to grant access in Azure AD and try again.
Once you have selected your desired workspace and report, simply schedule your bulletin and apply any other desired settings and select Publish.
Power BI bulletins will display across all Carousel Player types. The only difference in bulletin behavior is that because Apple TV’s can not display web based content, they will not update live, but will rather display a still image of the report which updates every 15 minutes.
The complexity and density of your reports will also effect the bulletin loading time on certain player types with limited processing capacity. Keeping your reports simple will help with longer loading times.