cancel
Showing results for 
Search instead for 
Did you mean: 

Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.

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
Memorable Member
Memorable Member

@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
Memorable Member
Memorable Member

@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
PBI November 2023 Update Carousel

Power BI Monthly Update - November 2023

Check out the November 2023 Power BI update to learn about new features.

Power BI Fabric Summit Carousel

The largest Power BI and Fabric virtual conference

130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.

Top Solution Authors
Top Kudoed Authors