March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early bird discount ends December 31.
Register NowBe one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch now
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.
@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
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
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
User | Count |
---|---|
90 | |
90 | |
83 | |
73 | |
49 |
User | Count |
---|---|
167 | |
149 | |
98 | |
73 | |
57 |