Power BI Embed Report with RLS

[Poojara_D12]

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.

[v-kpoloju-msft]

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

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

[v-kpoloju-msft]

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.

[Poojara_D12]

Hi @v-kpoloju-msft 

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.

[v-kpoloju-msft]

Hi @Poojara_D12,

After thoroughly reviewing the details you provided, I have identified alternative workarounds that may help resolve the issue. Please follow these steps:

• Ensure that the data source credentials are set up correctly and that the embedded service has the necessary access to connect. In many cases, the issue isn't with the report itself but rather with the data source permissions.

• Try using tools like Fiddler or your browser's developer tools (F12) to monitor network traffic while embedding the report. This can help identify any errors or failed requests, providing more insight into what might be causing the issue.

• Make sure the dataset ID is correctly linked to the embedded report. If the dataset binding isn’t set up properly, it can lead to issues with retrieving data.

• Check for any issues within the data model itself. Sometimes, errors in the data model can prevent it from being accessed properly when embedded.

• Try making a small update to the report, such as renaming it and then republishing. This simple step can sometimes resolve issues where the report isn’t displaying correctly when embedded.

• Ensure that the report and dataset are in a workspace with the appropriate licensing, such as Power BI Pro or Premium, to support embedding.

Please refer this following document for better understanding:
Troubleshoot Power BI embedded analytics application - Power BI | Microsoft Learn

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.

[v-kpoloju-msft]

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.

[Poojara_D12 · Accepted solution]

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.

[ibarrau]

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,