Forum Discussion
Filtering of a report
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,
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
ibarrau meaning if i use Row level security it would still work ? Which are the other softwares for embedding ?
When embedding in a web app, you own a code. You can actually apply any. You could use filters or RLS both would help.
An example of an Power Bi embedded solution as software is https://pibi.cloud
I hope that helps,