Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

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
v-qiuyu-msft
Community Support

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