Skip to main content

Power BI

New

Refine Excel Access via Permissions

Vote (1) Share
Stefan Jenkins's profile image

Stefan Jenkins on 13 Apr 2022 23:19:39

We have users that we want to build reports, but we don't want them access the data via Excel. If a user with elevated access uses Excel, they can use pivot tables to recreate large amounts of data (that may contain PII) and then they can very easily share it with other users. This can bypass security measures set in place by Row Level Security.


If it possible to separate out the Excel permissions from the report authoring permissions? We still want those users to be able to author and modify reports, but we want to hinder their ability to share private data.