cancel
Showing results for 
Search instead for 
Did you mean: 

Analyze In Excel Permissions

Hello,

 

I recently took away build permissions to datasets so that people cannot bring our datasets into their own PowerBI datasets (this is causing issues with us not being able to delete these datasets when we need to.) I noticed that Analyze In Excel is no longer functional on these datasets. Is this intended or is there a way to take away one permission without the other? 

 

https://docs.microsoft.com/en-us/power-bi/service-analyze-in-excel says that they should be able to Analyze In Excel with only the read permission, but this does not appear to be the case.

 

Thank you!

Status: New
Comments
Moderator

Hi @awhiteway

 

Based on my research, it requires Build permission on the dataset if we want to use Analyze in Excel feature. See: https://docs.microsoft.com/en-us/power-bi/service-datasets-build-permissions

 

"Build permission is only relevant for datasets. When you give users Build permission, they can build new content on a dataset, such as reports, dashboards, pinned tiles from Q&A, and Insights Discovery. They can also build new content on the dataset outside Power BI, such as Excel sheets via Analyze in Excel, XMLA, and export underlying data."

 

Best Regards,
Qiuyun Yu