Forum Discussion
Power BI Embed Report with RLS
Hello experts,
I'm facing an issue when I embed a Power BI report, I'm passing the correct workspace id and report id, when I load the embeded page, the layout of the report gets visible, but it doesn't show any records into it and shows a pop-up message.I've attached the screenshot below.
When I open the report in workspace I'm easily able to run it, refresh the data set as well. (Pro version of workspace)
If I change the report from the same workspace it is working correctly.
I hope if someone can help me with this.
Hi v-kpoloju-msft , ibarrau
Thank you so much for your answers.
The issue has been solved, the issue was with the RLS's parameter name, the name of the parameters were not matching in the c# code and the power bi, that was the reason behind this error. When I corrected the name it was working as expected.
7 Replies
Hi. Are you passing the identities with the effective identity? once the report has RLS you should include a role to make it load.
I hope that helps,
Hi Poojara_D12,
Thank you for reaching out to the Microsoft Fabric Community Forum. Thank you, ibarrau, for your valuable input regarding the issue.
After reviewing the details you provided, I have identified the alternative workarounds that may help resolve the issue. Please follow these steps:
- The report may be using a dataset that the embedded service cannot access. Ensure the dataset is in a Premium workspace if using Power BI embedded capacity. For live connections to a dataset, verify if the dataset is shared across workspaces, as embedding might have limitations.
- If the embedding setup lacks the necessary permissions, it may fail to retrieve the dataset. Ensure the embed token has the correct permissions for the workspace, report, and dataset.
- For datasets using Direct Query, ensure the data source is accessible from the embedding environment. If using an on-premises data gateway, confirm it is running and properly configured. Consider republishing the report under a different name and embedding it again.
- Some reports require explicit dataset binding when embedding. Verify that the dataset ID is correctly linked to the embedded report.
Please refer the below following links for more information:
Using standard cloud based row-level security with embedded content in Power BI embedded analytics - Power BI | Microsoft LearnAlso please go through the solved thread for better understanding:
Solved: Cannot load Model PowerBi Service - Microsoft Fabric Community
If this post helps, then please give us ‘Kudos’ and consider Accept it as a solution to help the other members find it more quickly.Best Regards.
Hi Poojara_D12,
May I ask if you have resolved this issue? If so, please mark the helpful reply and accept it as the solution. This will be helpful for other community members who have similar problems to solve it faster.
Thank you.
Thank you so much for your reply, unfortunately the issue is still not solved.
I tried to check an other report from the same workspace in where this report is published which I want to embed, the other report is working as expected, but the one which I developed is not working. I checked all the configurations and the settings of that report which is working with mine, nothing is different in it.
Also, when I refresh my report in the workspace with on demand refresh, it refreshes the dataset and there is no issue in it, but while embedding, it shows this error (above attached in screenshot) for data model.
I'm not sure what's going wrong with it.
.png){kind=link}