Analyze in Excel

Anonymous · ‎10-26-2020

The user was able to see Analyze in Excel option until last week. All of Sudden this option isnt avalaible now . What would be the reason for him not showing this option?

mahimabedi · ‎10-26-2020

Check it the user still has "built" permission on the dataset. That is essential for analyse in excel.

https://docs.microsoft.com/en-us/power-bi/connect-data/service-datasets-build-permissions#ways-to-gi...

PS: Please mark this post as a "solution" and/or hit the "thumbs-up" button if it helps you.

GilbertQ · ‎10-26-2020

Hi there

Can you also ask your Power BI Admin if they have changed any of the tenant admin settings?

Specifically the Export to Excel and Export data settings?

Did I answer your question? Mark my post as a solution!

Proud to be a Super User!

Power BI Blog