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

Power BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.

Share your ideas and vote for future features

Status: Investigating

Hi @SMHolck @mixieho ,

 

I will check with the internal team. Once I get a reply, will sync you here. Thanks for your understanding!

 

Best Regards,

Community Support Team _ Caiyun

  • Content Packs
Status: Delivered
  • Content Packs
Status: Investigating
Status: Accepted
Status: Investigating
Status: Delivered
  • Content Packs
Status: Delivered
Status: New
Status: New
Status: Accepted
Status: Investigating
Status: Needs Info
  • Content Packs
Status: Investigating

Hi @Anonymous 

 

May I know whether you have installed Analyze in Excel updates and open the workbook that generated by Power BI with it? There are some requirements and limitations on using Analyze in Excel, please check whether there is any item causing this issue firstly.

  • Analyzing Power BI data in Excel is supported for Microsoft Excel 2010 SP1 and later.
  • Excel PivotTables don't support drag-and-drop aggregation of numeric fields. Your dataset in Power BI must have pre-defined measures.
  • Analyzing Power BI data in Excel requires that the dataset be in a Power BI Premium workspace or that you have a Power BI Pro or Premium Per User (PPU) license.
  • You can connect to Power BI datasets in Excel if you have permission for the underlying dataset. You could have this permission in a few ways. You could have the Member role in the workspace containing the dataset, or have Build permission for a dataset in a workspace, or in an app that contains the dataset.
  • You can only analyze Power BI data in Excel on computers running Microsoft Windows.
  • Only Power BI datasets that use Import mode will preserve hierarchies in Analyze in Excel workbooks. Power BI datasets built on DirectQuery or composite models will not have their hierarchies retained when using Analyze in Excel.
  • You may see an error message if the data is larger than 2 GB. In that case, either reduce the amount of data, for example by applying filters, or use the XMLA endpoint. Learn more about the XMLA endpoint.
  • Guest users can't analyze Power BI data in Excel for datasets sent from (originating from) another tenant.
  • Analyzing Power BI data in Excel is a Power BI service feature. You can't analyze Power BI data in Excel from Power BI Report Server or Power BI Embedded

For more details, please refer to Connect Excel to Power BI datasets - Power BI | Microsoft Docs and Start in Power BI with Analyze in Excel - Power BI | Microsoft Docs.

 

Best Regards,

Community Support Team _ Caiyun

  • Content Packs
Status: Delivered
  • Content Packs
Status: Accepted
  • Content Packs
Status: Accepted

Currently it has been considered as a known issue which would be fixed in the early of September, so please stay tuned.

 

Best Regards,
Community Support Team _ Yingjie Li

Status: Accepted
Status: New
Status: New
Status: New
  • Content Packs
Idea Statuses