Forum Discussion
Filtering of a report
I have a report which has 20 divisions in it .I want to display each division with there specific report instead of creating 20 pages for 20 divisions .Is there a way I could filter this information so that I could embedd it in the various divisions ?
Hi. Yes, correctme if I wrong but it sounds like you want one page that would change division depending who is accessing the data at Power Bi Service.
You can do it with Row Level Security. Take a look at this: https://learn.microsoft.com/en-us/power-bi/enterprise/service-admin-rls
You can create roles in Power Bi Desktop and asign that for people to filter a report for that people. That way you can build one page that will change automatically depending on the division.
I hope that helps,
5 Replies
Hi. Yes, correctme if I wrong but it sounds like you want one page that would change division depending who is accessing the data at Power Bi Service.
You can do it with Row Level Security. Take a look at this: https://learn.microsoft.com/en-us/power-bi/enterprise/service-admin-rls
You can create roles in Power Bi Desktop and asign that for people to filter a report for that people. That way you can build one page that will change automatically depending on the division.
I hope that helps,
Thank you ibarrau .Is there a way where by People can just view rather than me assigning roles ?
PS: Its on an intranet so I was thinking of embedding different links to different divisions rather than creating the pages will this work ?
Well, if you are embedding in an internal web app, you can write a code in order to send a filter to the report before showing it. That way each section of the intranet app would have a different code calling the report with some parameters. This way of embedding is the one with a capacity license that involves coding, and it's not the "iframe link" secure code.
That would be another approach. There are softwares for embedding in case you want that way. Otherwise if you would use Power Bi Service the roles are the best alternatives.
Regards