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

Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now

Reply
MacJasem
Helper III
Helper III

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 accounts.

 

Hope you can help me understand why some of my report end-users have the Extract -> Analyze in Excel option grayed out, and most of the other end-users have the option to extract a analyze in excel file?

 

It seems odd that they have similar access and pro-licenses but some have restricted options with regards to Analyze in Excel and som don't.

1 ACCEPTED SOLUTION
MiquelPBI
Helper I
Helper I

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!

 

View solution in original post

4 REPLIES 4
MiquelPBI
Helper I
Helper I

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!

 

amitchandak
Super User
Super User

@MacJasem , Make sure this is checked at organization level or for the user you are looking for. This is under tenant setting in the Admin portal

amitchandak_0-1706609375382.png

 

Join us as experts from around the world come together to shape the future of data and AI!
At the Microsoft Analytics Community Conference, global leaders and influential voices are stepping up to share their knowledge and help you master the latest in Microsoft Fabric, Copilot, and Purview.
️ November 12th-14th, 2024
 Online Event
Register Here

@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? 

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.

Helpful resources

Announcements
OCT PBI Update Carousel

Power BI Monthly Update - October 2024

Check out the October 2024 Power BI update to learn about new features.

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

October NL Carousel

Fabric Community Update - October 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors