Forum Discussion

MacJasem's avatar
MacJasem
Advocate II
2 years ago
Solved

Analyze in Excel Grayed Out?

Hi guys   Let me first set the scenario:   I have different workspaces with different reports, but all report end-users are given access to their report via App using their own tenant mail accoun...
Need Help
Show and Tell
Tips and Tricks
  • MiquelPBI's avatar
    MiquelPBI
    2 years ago

    Hello MacJasem !  Double checking the tenent settings is a good first step.  Next check the workspace permissions for those users that dont have the option enabled. 

     

    The docs have the prereqs outlined:

    • Your organization’s tenant administrator must enable the Users can work with Power BI semantic models in Excel using a live connection tenant setting. Learn more about the Excel live connection tenant setting in the admin portal documentation.
    • For on-premises datasets, your organization’s tenant administrator also must enable the Allow XMLA endpoints and Analyze in Excel with on-premises datasets tenant setting. Learn more about the Allow XMLA endpoints tenant setting in the admin portal documentation.
    • You must have Build permission to the Power BI semantic model or have at least a Contributor role in the Power BI workspace containing your semantic model.
    • You must have a Power BI license: Fabric Free, Pro or Premium Per User (PPU). Fabric Free license users can only work with datasets in My workspace or a Power BI Premium capacity or Fabric F64 or greater capacity. Learn more about Power BI licenses.
    • You can use Excel workbooks containing refreshable Power BI data in both Excel Desktop and Excel for the web.

    HTH!

     

MacJasem's avatar
MacJasem
Advocate II
2 years ago

amitchandak i don't have access to these settings, but i wonder if this is really the issue, when some of my report end users have the option to extract an Analyze in Excel file and some don't? 

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi MacJasem 

 

amitchandak  GOOD ANSWER!

 

The level of workspace roles and licenses is one of the reasons for this, perhaps you can double check that these users have consistent permissions and licenses.

 

You can check if the affected users have access to the Analyze in Excel feature in other workspaces or reports.

 

For more information about the Admin Portal, see the following documentation:

How can i see power BI admin panel? - Microsoft Community

 

Best Regards,
Community Support Team _Yuliax

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.