cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Frequent Visitor

Dyanamic filtering of power bi report in apps/applications

Hi,

 

I want to create a power bi report and embed that into our own in-house developed application. 

I want a functionality like this:

1. The user uses his/her credentials to login to that application.

2. User can see the power bi report of data meant to be viewed by him/her only(The data is personal and users should not be able to see each other's reports, at any cost).

 

In effect, I want to either import dynamically pre-filtered data or  use a dynamically developed direct query which will give me pre-filtered data. 

I have the user's name column in one of the tables in DB.

Is this possible in Power-BI or via using other connections like Analysis Services in Power BI.

Note: Creating power bi reports for each user separately is not an ideal case, because there will be hundreds of users.

Any help will be really appreciated.

Thanks!!

 

2 ACCEPTED SOLUTIONS

Accepted Solutions
Highlighted
Super User III
Super User III

Re: Dyanamic filtering of power bi report in apps/applications

Hey @Hussain ,

 

the feature you are looking for is called Row Level Security (RLS). RLS allows to define roles that restrict users to a certain subset of data inside a dataset, avoiding to create indiviual reports.

This article provide a introduction in to RLS: https://docs.microsoft.com/en-us/power-bi/admin/service-admin-rls

RLS is supported in embedding scenarios, a report/dashboard is embedded into your own web app, and of course by applications inside the Power BI Service.

 

Hopefully, this gets you started.

 

Regards,

Tom



Did I answer your question? Mark my post as a solution, this will help others!

Proud to be a Super User!
I accept Kudos 😉
Hamburg, Germany

View solution in original post

Highlighted
Community Support
Community Support

Re: Dyanamic filtering of power bi report in apps/applications

Hi @Hussain ,

 

You may set Row-Level Security (RLS) to manage roles,  please see the link Power BI Desktop Dynamic security cheat sheet, which described the detailed steps. Maybe it doesn't work, there are some tips to let it work and test it efficiently.

 

If you're embedding to Power BI users (user owns data), within your organization, RLS works the same as it does within the Power BI service directly. There's nothing more you need to do in your application. See more : Row-level security with Power BI Embedded.

 

Best Regards,

Amy 

 

Community Support Team _ Amy

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

View solution in original post

2 REPLIES 2
Highlighted
Super User III
Super User III

Re: Dyanamic filtering of power bi report in apps/applications

Hey @Hussain ,

 

the feature you are looking for is called Row Level Security (RLS). RLS allows to define roles that restrict users to a certain subset of data inside a dataset, avoiding to create indiviual reports.

This article provide a introduction in to RLS: https://docs.microsoft.com/en-us/power-bi/admin/service-admin-rls

RLS is supported in embedding scenarios, a report/dashboard is embedded into your own web app, and of course by applications inside the Power BI Service.

 

Hopefully, this gets you started.

 

Regards,

Tom



Did I answer your question? Mark my post as a solution, this will help others!

Proud to be a Super User!
I accept Kudos 😉
Hamburg, Germany

View solution in original post

Highlighted
Community Support
Community Support

Re: Dyanamic filtering of power bi report in apps/applications

Hi @Hussain ,

 

You may set Row-Level Security (RLS) to manage roles,  please see the link Power BI Desktop Dynamic security cheat sheet, which described the detailed steps. Maybe it doesn't work, there are some tips to let it work and test it efficiently.

 

If you're embedding to Power BI users (user owns data), within your organization, RLS works the same as it does within the Power BI service directly. There's nothing more you need to do in your application. See more : Row-level security with Power BI Embedded.

 

Best Regards,

Amy 

 

Community Support Team _ Amy

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

View solution in original post

Helpful resources

Announcements
Community Blog

Community Blog

Visit our Community Blog for articles, guides, and information created by fellow community members.

Using the Community

Using the Community

Need help with the Power BI Community? Our 'Using the Community' support articles are a great place to start.

Community Summit North America

Community Summit North America

Innovate, Collaborate, Grow. The top training and networking event across the globe for Microsoft Business Applications

Power Platform 2020 release wave 2 plan

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Top Solution Authors
Top Kudoed Authors