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

Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes! Register now.

Reply
kvnbn
Frequent Visitor

Share report without sharing access to dataset

I work for a small business that wants to share reports with our external clients. We only want them to see the reports and dashboards. They should not be able to:

  1. View the dataset.
  2. Export the reports/dashboards

We have given our clients Direct Access to the reports rather than through Links. They currently only have the Read permission. Is that sufficient for disabling both of the options above? What happens when they try to click on ... > View Dataset from the report? 

1 ACCEPTED SOLUTION
lbendlin
Super User
Super User

Are you designing your reports in Power BI Desktop or in the service?

 

In the desktop you can block exporting for Reports.  

lbendlin_0-1686874802055.png

Dashboards have their own sets of controls.  (They have no concept of "Export").

lbendlin_1-1686874965931.png

 

To try and prevent access to datasets remove the Build permissions.

 

In general your attempt is futile. If you don't want users to "steal" (copy, export etc) your data then your only choice is to NOT SHOW THEM your data.

 

View solution in original post

3 REPLIES 3
lbendlin
Super User
Super User

Are you designing your reports in Power BI Desktop or in the service?

 

In the desktop you can block exporting for Reports.  

lbendlin_0-1686874802055.png

Dashboards have their own sets of controls.  (They have no concept of "Export").

lbendlin_1-1686874965931.png

 

To try and prevent access to datasets remove the Build permissions.

 

In general your attempt is futile. If you don't want users to "steal" (copy, export etc) your data then your only choice is to NOT SHOW THEM your data.

 

Thank you. I designed these in desktop, so I followed your directions and disabled the exporting. Our clients only have Read permissions and not Build permissions. When I open the dataset, I can see this page (details and table names have been whited out), and I can click on the tables/columns to see the data in a Table preview. Would my Read-only users be able to do this?

 

Read.png

kvnbn_0-1686932865594.png

 

I would guess so. You would have to test that with actual users from your external clients.  I assume you are also aware of the Power BI Embedded scenarios and the difference between "app owns data"  and "user owns data" .

 

My previous statement still stands: If you don't want users to "steal" (copy, export etc) your data then your only choice is to NOT SHOW THEM your data.

Helpful resources

Announcements
September Power BI Update Carousel

Power BI Monthly Update - September 2025

Check out the September 2025 Power BI update to learn about new features.

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.

Top Solution Authors
Top Kudoed Authors