Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
My client has recently decided to expand their business to a second country. The data loaded into PBI is retrieved from a single data warehouse that will contain data for both countries and can be filtered using a Company field. Let's say the field is populated with US and CA.
I enabled RLS roles (US Only and CA Only) from within the desktop. The report is published to two different workspaces, and each workspace has people added to the appropriate roles so if they enter that workspace report they can see that country's information. Some users are added to both roles.
Everything was working fine except for one thing... the intranet web portal that also displays the report using an iframe (embed code from the PBI web app) stopped working. No surprise because I added the RLS which deactivated the Publish to Web embed code. My mission now is do the following:
I found this page thanks to Guy in a Cube that outlines how to embed a report into a web page using REST APIs: https://powerbi.microsoft.com/en-us/documentation/powerbi-developer-integrate-report/
Is this the simplest way to do it? Are there any other videos/blogs that give a step by step on how to accomplish?
Are there other methods to consider? For instance, I could (not that I want to) duplicate my pbix then modify the SQL statements in the second version to pull in the other country, but that means I’m stuck doing that each time I publish a new version of the report. It seems like 15 minutes of wasted time.
Thanks for your ideas.
Hi @Greg_Deckler,
According to your description above, I think using Power BI Embedded is a good choice here in your scenario, as Power BI Embedded now supports datasets configured with RLS. For more details about Row level security with Power BI Embedded, you can refer to this article.
Regards
If the Intranet is SharePoint Online, there is a web part for it. I'm assuming that's not the case?
@smoupre wrote:If the Intranet is SharePoint Online, there is a web part for it. I'm assuming that's not the case?
No sharepoint. Just an in-house developed intranet web portal.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.