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

Be 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

Reply
Anonymous
Not applicable

Privacy of published report on public website

Hello,

I was wondering what data can be accessed by the user when a report is published on the public web.

According to the warning Power Bi gives when publishing a report the data can be seen by anyone.

The question is if the whole dataset is public after only displaying a couple of variables in the report.

Any help is appreciated!

2 ACCEPTED SOLUTIONS
nandic
Super User
Super User

@Anonymous , online users will be able to interact with the report and export summarized or underline data (depending on settings), but they will not be able to get inside the model, relationships, full data that stands behind the report.

View solution in original post

Tahreem24
Super User
Super User

@Anonymous ,

When you use publish to web option for sharing your report  so whoever access that link can able to interact with the visuals and reports but not with the actual data, any transformations applied on this data, Calculated fields (measure, column), relationships. Moreover, they can't export the report or visual's data.

In future owner of the this report can disable the link so it will inactive or invalid for global users .

 

Don't forget to give thumbs up and accept this as a solution if it helped you!!!

Please take a quick glance at newly created dashboards : Restaurant Management Dashboard , HR Analytics Report , Hotel Management Report, Sales Analysis Report , Fortune 500 Companies Analysis , Revenue Tracking Dashboard

View solution in original post

7 REPLIES 7
amitchandak
Super User
Super User

@Anonymous , user can download most of the data

 

refer, if these can help to control that

https://community.powerbi.com/t5/Service/Share-report-dataset-in-Power-BI-Service-without-allowing-pbix/td-p/542477

https://docs.microsoft.com/en-us/power-bi/visuals/power-bi-visualization-export-data

Join us as experts from around the world come together to shape the future of data and AI!
At the Microsoft Analytics Community Conference, global leaders and influential voices are stepping up to share their knowledge and help you master the latest in Microsoft Fabric, Copilot, and Purview.
️ November 12th-14th, 2024
 Online Event
Register Here
Tahreem24
Super User
Super User

@Anonymous ,

When you use publish to web option for sharing your report  so whoever access that link can able to interact with the visuals and reports but not with the actual data, any transformations applied on this data, Calculated fields (measure, column), relationships. Moreover, they can't export the report or visual's data.

In future owner of the this report can disable the link so it will inactive or invalid for global users .

 

Don't forget to give thumbs up and accept this as a solution if it helped you!!!

Please take a quick glance at newly created dashboards : Restaurant Management Dashboard , HR Analytics Report , Hotel Management Report, Sales Analysis Report , Fortune 500 Companies Analysis , Revenue Tracking Dashboard

@Anonymous , just pay attention to some visualizations like bar chart, when you right click on bar there is option "Show data point as table". Make sure only relevant data is displayed.
@Tahreem24 export is not enabled by default, but for example if i click on option from above "Show data point as table" it displays list. If i click ctrl + A and paste in Excel it will copy data from list. 
Tested on several published to web reports.

@nandic ,

Publish to web URL doesn't support "Show data in a Table" option. 

 

Don't forget to give thumbs up and accept this as a solution if it helped you!!!

Please take a quick glance at newly created dashboards : Restaurant Management Dashboard , HR Analytics Report , Hotel Management Report, Sales Analysis Report , Fortune 500 Companies Analysis , Revenue Tracking Dashboard

@nandic ,

If you check the link in my signature so I am using "Publish to web" option in that link without any setting. And by default it won't show "Show as a Table" option on any visuals. So, users can't export data from visuals from this publish to web option.

Don't forget to give thumbs up and accept this as a solution if it helped you!!!

Please take a quick glance at newly created dashboards : Restaurant Management Dashboard , HR Analytics Report , Hotel Management Report, Sales Analysis Report , Fortune 500 Companies Analysis , Revenue Tracking Dashboard

@Tahreem24 , i agree that there is no default option for export. 
But for example, if you had several thousands of rows under data view tab on your report, i get to that page, ctrl + A and i will paste it in Excel. It will set everything in one column, but if there is a pattern (ie: in this case we have 20 rows) we can easily transform this one column into usable table.
So i just wanted to point out that if we use publish to web we should publish only non-confident data, otherwise it can be used by others. 

export manual.PNG

nandic
Super User
Super User

@Anonymous , online users will be able to interact with the report and export summarized or underline data (depending on settings), but they will not be able to get inside the model, relationships, full data that stands behind the report.

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

Dec Fabric Community Survey

We want your feedback!

Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions.

ArunFabCon

Microsoft Fabric Community Conference 2025

Arun Ulag shares exciting details about the Microsoft Fabric Conference 2025, which will be held in Las Vegas, NV.

December 2024

A Year in Review - December 2024

Find out what content was popular in the Fabric community during 2024.