Embed Power BI Report that Uses a Semantic Model

Question

Hi,I have a website that contains several Power BI Embeded Reports. They are embeded utilizing JSON scripting. However, they all currently have their reports and datasets in the same workspace.&nbsp;&nbsp;I have a need to embed a report on the website that utilizes a semantic model - meaning the report(s) are in one workspace and the Dataset they are connected to resides on another workspace.&nbsp;When I enter the Group, Report, and Dataset IDs, the report does not display.&nbsp; My assumption is that the embed process is getting confused because it is expecting the Report and the Dataset to be in the same Group/workspace ID.&nbsp;Is this possible to do this?&nbsp;The code I am using is below:&nbsp;{&nbsp;&nbsp;&nbsp; "json": {&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; "identities": [&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; {&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; "roles": [&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; "RegionRestricted"&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ],&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; "datasets": [&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; "xxx"&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ],&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; "username": "THIRD_PARTY"&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; }&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ],&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; "accessLevel": "View"&nbsp;&nbsp;&nbsp; },&nbsp;&nbsp;&nbsp; "groupId": "xxx",&nbsp;&nbsp;&nbsp; "reportId": "xxx",&nbsp;&nbsp;&nbsp; "settings": {&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; "filterPaneEnabled": false,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; "navContentPaneEnabled": false&nbsp;&nbsp;&nbsp; }}

danielreinman · Answer

Thank you for the response. However the issue I am encountering is not that I have multiple reports; wehave already solutioned for this and applied RLS that works effectively, based upon the UPN of whomever is accessing the data. The issue seems to me that the Dataset and report reside in entirely different workspaces, so the group ID related to the dataset is different than the group ID related to the report. Are you aware of a way to overcome this? Should I be listing both Group IDs in the code?

anonymous · Answer

Hi&nbsp;DanielReinman&nbsp;
&nbsp;
Power BI Embedded allows us to generate one Embed Token to bind multiple datasets and reports.
You can make some changes in the profiles you bind to the dataset:
--------------------------------------------------------
{
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; …
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; "datasets": [
&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;{
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; "id": "xxx1"
&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;},
&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;{
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; "id": "xxx2"
&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;}
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;],
&nbsp; "reports": [
&nbsp;&nbsp;&nbsp; {
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; "id": "xxxx"
&nbsp;&nbsp;&nbsp; }
…
}
--------------------------------------------------------
After that, different RLS role needs to be bound to the corresponding dataset:
For example, in the following picture that the first dataset corresponds to the role of ‘sales’, and the second dataset corresponds to the role of ‘executive’.

Link of RLS in embedded token:
Using standard cloud based row-level security with embedded content in Power BI embedded analytics - Power BI | Microsoft Learn
Link of example of generating an embed token for two datasets with RLS identities.
Embed Token - Generate Token - REST API (Power BI Power BI REST APIs) | Microsoft Learn
&nbsp;
Best Regards,
Zhengdong Xu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Forum Discussion

Embed Power BI Report that Uses a Semantic Model

2 Replies

Related content

One Semantic Model for Multiple Reports

power bi report based on multiple semantic models

Embed Paginated Report

Issues with Report Refresh – Semantic Model Stuck

Disable embed reports