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

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
BI12345
New Member

External sharing of restricted PBI dataset

We want to share a sample of our main PBI dataset/database with a client, who is mostly interested in the datamodel and how our measures etc. have been calculated.

But I can't seem to find a solution where we are able to restrict the client's overall data access (e.g. number of rows in a table - did attempt with RLS but doesn't work when configured as more than "Viewer"), and still enable them to download a dataset and manipulate and view measures. 

1 ACCEPTED SOLUTION
v-cazheng-msft
Community Support
Community Support

Hi @BI12345,

 

If you would like a user been restricted by RLS, then you could only add this user as Viewer to the dataset workspace. Any roles greater than Viewer won’t been applied RLS for they can see all the report data. But if you hope this user download a pbix file from dataset, this user needs to be at least a Contributor. Download a report from the Power BI service to Power BI Desktop - Power BI | Microsoft Learn.

 

If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please let me know. Thanks a lot!

 

Best Regards,

Community Support Team _ Caiyun

View solution in original post

1 REPLY 1
v-cazheng-msft
Community Support
Community Support

Hi @BI12345,

 

If you would like a user been restricted by RLS, then you could only add this user as Viewer to the dataset workspace. Any roles greater than Viewer won’t been applied RLS for they can see all the report data. But if you hope this user download a pbix file from dataset, this user needs to be at least a Contributor. Download a report from the Power BI service to Power BI Desktop - Power BI | Microsoft Learn.

 

If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please let me know. Thanks a lot!

 

Best Regards,

Community Support Team _ Caiyun

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Power BI Monthly Update - May 2024

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

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

Top Solution Authors