Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

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 ...
Need Help
Show and Tell
  • ibarrau's avatar
    ibarrau
    2 years ago

    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's avatar
Anonymous
Not applicable
2 years ago

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

ibarrau's avatar
ibarrau
Icon for Super User rankSuper User
2 years ago

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,