Forum Discussion
App Dataset Security
There is actually a new setting in the Power BI Service, for each report where you can specify the exporting reporting options as shown below.
You can go into the reports, then click on the settings icon.
I always recommend leaving the Summarized data, because that is what makes up the visual
Hi,
Thank you, that looks useful,
Am I right in thinking that for every report we publish that needs to have underlying data protected we will have to hide all the individual tables in designer and also set the export data option in the service? (Have I missed any other ways for users to get at the data?)
Seems like it would be easy to accidentaly expose data or am I missing something?
Phil
- Hi there,
Read only users will not see any tables. And to be realistic the users will always see the summerized data which is shown in the visualsHi,
It looks like the app users are able to click on the app contents button and see the datasets, from there they can run quick insights or (if they are a pro user) can use the analyse in Excel function to download the data. I have a feeling there are probably other ways for them to get to the data as well.
The only way I can see to secure data is to pre-aggregate (which seems to be confirmed in a related thread I started here)
IT would be great if there was a way to tick a box and secure all underlying data on a report by report basis but Power BI doesn't seem to have been built that way.
