| Info |
|---|
Please note that this feature is only available if the right license has been acquired. Contact your Account Manager for more information. |
Power BI with Web View Controls
A web view control is used to embed Power BI report to populate the correct POV based on the selections made in the CXO report. The URL consists of link to the Power BI app, followed by the Power BI report ID, followed by the filter for the name of the table and the dimension that is being used to embed it into CXO, which is equal to the mapping.
The following URL shows how it is used:
https://app.powerbi.com/reportEmbed?reportId=25d7baa5-f8f7-4f64-b7ed-ad30000bea26&autoAuth=true&ctid=2f3aa76a-89a8-4468-9894-2b4842b9534b&$filter=TestTable/Entity eq '[ENT].Name', where:
$filter= : Defines the filter
TestTable : Table
Entity: Field
eq : Query operator
[ENT]: Is the member for a dimension defined in a dynamic string replacement
For additional information on creating this URL, please check this documentation:
https://learn.microsoft.com/en-us/power-bi/transform-model/desktop-create-and-manage-relationships In the Configurator, click on Power BI Settings.
...
Add Azure Tenant Id, Azure Application ID and Azure Client Secret as defined on thePower BI site and click Save.
...
Creating a Free-Format Report using Power BI Control
Log into CXO and access the CXO-Designer to build a new Free Format Report
From under CONTROL SETTINGS click + Add Control and select Power BI option.
Under Power BI add the mandatory values for Workspace ID and Report ID. Dataset Id is optional. Specify the user filters under the roles if applicable. Add value specifying the POV(s) to be used under Filter in the following format:
name of the report/name of the filter eq’[PER].Name’ for example:
...
Separate each filter by adding “and” in case of more than one filter being used.
...
Export a Power BI report
A power BI report can be exported from CXO by clicking on the export button:
...
Requirements to embed Power BI content
A tenant-level Microsoft 365 subscription available in two SKU families, EM and P or
Azure Power BI Embedded resource
Export iframe embedding vs Embed token Power BI Reports
Override CXO POV Member Name
...
app.powerbi.com/reportEmbed?reportId=25d7baa5-f8f7-4f64-b7ed-ad30000bea26&autoAuth=true&ctid=2f3aa76a-89a8-4468-9894-2b4842b9534b&$filter=TestTable/Entity eq '[TestTable].[ENT].Name'
If the user has two tables with the same name in Power BI, they can add a second column in Source System Matches which will have a different DisplayName. For example:
A new column that uses TestTable is added, with
DisplayNameTestTable_2The URL to refer it would be:
app.powerbi.com/reportEmbed?reportId=25d7baa5-f8f7-4f64-b7ed-ad30000bea26&autoAuth=true&ctid=2f3aa76a-89a8-4468-9894-2b4842b9534b&$filter=TestTable/Entity eq '[TestTable_2].[ENT].Name'
Related:
...