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

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register 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
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
Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

February 2024 Update Carousel

Power BI Monthly Update - February 2024

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

Fabric Career Hub

Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

Fabric Partner Community

Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.

Top Solution Authors