Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

Reply
renecernitz
Frequent Visitor

External Sharing with limited data access

Hi everyone,

 

In my company we want to share a dashboard for our clients (external to our organization).

 

We have created a dashboard with all clients data in such a way that, internally, we can see the figures of a single, or a group of clients, through a slicer.

 

The problem is that we want to share this dashboard but each clients can only see their data, not all the data.

Is there any possibility to restrict access only to their data?
Can this be done if I share the dashboard through a link? Or do I have no choice but to create a report per installation with only their data?

 

Thanks in advance for your help 😊

 

 

1 ACCEPTED SOLUTION
Burningsuit
Resident Rockstar
Resident Rockstar

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

View solution in original post

3 REPLIES 3
Burningsuit
Resident Rockstar
Resident Rockstar

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 

Helpful resources

Announcements
Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

February 2024 Update Carousel

Power BI Monthly Update - February 2024

Check out the February 2024 Power BI update to learn about new features.

Fabric Career Hub

Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

Fabric Partner Community

Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.

Top Solution Authors
Top Kudoed Authors