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

Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now

Reply
rashig
Frequent Visitor

Filter Power BI Report embedded in a web application from Power BI Report Server

Good morning everyone,

I am working on embedding and filtering Power BI report hosted from Power BI Report Server. I have successfully been able to embed Power BI report from web application using:

<iframe src="http://PowerBIReportServer?rs:embed=true"></iframe>

 

Along with this I also wanted to show report data based on the user has logged in, which I have been able to achieve using:

<iframe src="http://PowerBIReportServer?rs:embed=true&filter=TableName/ColumnName eq 'Value'"></iframe>

 

But using this method one user is able to see data of other user by editing the data in the browser. Is there any secure way of doing the filtering for Power BI reports hosted on Power BI report server?

4 REPLIES 4
luisrh
Responsive Resident
Responsive Resident

We create our own authentication provider on top of PBI RS.   We don't use the out of the box AD provider.  Also,  is the pbix using a direct connection or an import model?    You can use RLS with both implementations.  

luisrh
Responsive Resident
Responsive Resident

Yes...  using Row level security.      This works on power bi report server.   Just make sure your server is a version beyond May 2020 to be safe.

Row-level security (RLS) with Power BI - Power BI | Microsoft Docs

 

regards,

Luis H

rashig
Frequent Visitor

Thank you for your quick response and help. With row level security we need to always add members and we have 100+ customers and with every new customer we will have to manage addition or deletion of members. Is there a workaround for this?

Hi @rashig ,

 

You can apply ad group to the rls role. Please refer to https://www.fourmoo.com/2018/02/20/dynamic-row-level-security-is-easy-with-active-directory-security...

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

 

Best Regards,

Dedmon Dai

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.

Nov PBI Update Carousel

Power BI Monthly Update - November 2024

Check out the November 2024 Power BI update to learn about new features.

October NL Carousel

Fabric Community Update - October 2024

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