March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early bird discount ends December 31.
Register NowBe 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
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!
Solved! Go to Solution.
@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.
@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 .
@Anonymous , user can download most of the data
refer, if these can help to control that
https://docs.microsoft.com/en-us/power-bi/visuals/power-bi-visualization-export-data
@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 .
@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.
@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.
@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.
@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.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions.
Arun Ulag shares exciting details about the Microsoft Fabric Conference 2025, which will be held in Las Vegas, NV.
User | Count |
---|---|
129 | |
90 | |
75 | |
58 | |
53 |
User | Count |
---|---|
200 | |
104 | |
101 | |
67 | |
55 |