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

Create report that filter on user viewing the report?

I have an organisation that have many guests in our tenant.

We have one large powerbi report that display data about the customers.

We want the customers to be able to view this report but i want the report to filter on logged in user.

 

We have Microsoft teams per customer that they are member in.

So my idea is to filter on logged in user if he/she is member of team with id-number x then show data related to that id-number.

 

If this is not possible. I need to create a massive amount of reports and push out into each team so the guest-users (customers) can view them.

 

 

2 REPLIES 2
amitchandak
Super User
Super User

@Oskar , to distribute report to external user you have option like

https://docs.microsoft.com/en-us/power-bi/admin/service-admin-azure-ad-b2b

 

or you check embedded power bi

Syk
Super User
Super User

Sounds like you need row level security (RLS). Lots of good info out there, to start you should check out Microsoft's documentation.
https://docs.microsoft.com/en-us/power-bi/admin/service-admin-rls

Helpful resources

Announcements
PBI Sept Update Carousel

Power BI September 2023 Update

Take a look at the September 2023 Power BI update to learn more.

Learn Live

Learn Live: Event Series

Join Microsoft Reactor and learn from developers.

Top Solution Authors