Forum Discussion
External Sharing with limited data access
Hi renecernitz
What you want is called Row Level Security (RLS) in Power BI.
This restricts the data users can see on a Report by login name. So you can create one report, share it with 10 other users and they will only see the data that is applicable to them.
You can find the microsoft documentation on RLS here Row-level security (RLS) with Power BI - Power BI | Microsoft Docs
other useful links are here (53) What is Row-Level Security (RLS) in Power BI??? - YouTube
Hope this helps
Stuart
Hi renecernitz
What you want is called Row Level Security (RLS) in Power BI.
This restricts the data users can see on a Report by login name. So you can create one report, share it with 10 other users and they will only see the data that is applicable to them.
You can find the microsoft documentation on RLS here Row-level security (RLS) with Power BI - Power BI | Microsoft Docs
other useful links are here (53) What is Row-Level Security (RLS) in Power BI??? - YouTube
Hope this helps
Stuart
Thanks 🙂 I was just looking at it but a I have a doubt.
Do all these external users need to have previously created a Power BI account?
Yes, for RLS to work the users require Power BI accounts. That is how Power BI works out what data to show to each user. The accounts can be Free accounts if the Dataset is hosted on a Premium Capacity Workspace, or the appropriate Pro or PPU licence if not.
Without a Power BI licence there is no way to work out who the user is. If you can't work out who the user is, you cannot restrict them to only their data. That's why you need a Power BI Licence for RLS to work.
Hope this helps
Stuart