Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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.