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!

     

MiquelPBI's avatar
MiquelPBI
Helper I
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!