Filtering of a report

[Anonymous]

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 ?

[ibarrau · Accepted solution]

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,

[Anonymous]

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 ?

[ibarrau]

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

[Anonymous]

@ibarrau meaning if i use Row level security it would still work ? Which are the other softwares for embedding ? 

[ibarrau]

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,