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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

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
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
Sept PBI Carousel

Power BI Monthly Update - September 2024

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

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

Sept NL Carousel

Fabric Community Update - September 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors