Join us for an expert-led overview of the tools and concepts you'll need to pass exam PL-300. The first session starts on June 11th. See you there!
Get registeredPower BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.
I have built a report with a dataset I would like to protect from another user. I would like to give access to the pbi file and allow them to export the data to excel from a table visual in power bi desktop, the only limitation I want is that the person cannot access the complete data in power query and export the complete dateset in power query to excel. What restrictions can I place to achieve this.
Solved! Go to Solution.
Hi @akhaliq7 ,
unfortunately this is not possible at the PBIX-file level. Once you give the PBIX-file, the user has access to the whole file and all the data inside. Unless you're using Direct Query to get the data, then the user also needs access to the source.
But if you want to give access to (a portion of) a report, I'd suggest publishing it to the service and going from there. For example with row-level security or putting a report in an app and sharing that with the user.
Hi @akhaliq7 ,
unfortunately this is not possible at the PBIX-file level. Once you give the PBIX-file, the user has access to the whole file and all the data inside. Unless you're using Direct Query to get the data, then the user also needs access to the source.
But if you want to give access to (a portion of) a report, I'd suggest publishing it to the service and going from there. For example with row-level security or putting a report in an app and sharing that with the user.
User | Count |
---|---|
48 | |
31 | |
27 | |
26 | |
26 |
User | Count |
---|---|
60 | |
56 | |
36 | |
32 | |
28 |