Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
SCTDev
Helper I
Helper I

RLS and intranet website

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:

 

  1. Have a single version of the report, if possible.  It is too difficult to make small changes like moving visuals around and making the changes identical in a second report.
  2. Avoid using Azure because my client does not want to encounter additional expense. They are already on the Pro plan for all who have access to the report.
  3. The intranet requires the user to log in, and their credentials could be passed to PBI. It looks like we can use REST APIs.

 

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.

 

3 REPLIES 3
v-ljerr-msft
Employee
Employee

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

 

Regards

Greg_Deckler
Super User
Super User

If the Intranet is SharePoint Online, there is a web part for it. I'm assuming that's not the case?


@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
Mastering Power BI 2nd Edition

DAX is easy, CALCULATE makes DAX hard...


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

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors