Forum Discussion

Copper Contributor

Feb 23, 2022

Power BI hierarchies missing when data model consumed in Excel

I posted this issue in the Power BI forums. https://community.powerbi.com/t5/Issues/Power-BI-hierarchies-missing-when-data-model-consumed-in-Excel/idc-p/2352639#M76224 After internal review, the Po...

Copper Contributor

Jun 20, 2023

This is an issue in Fabric's Direct Lake mode as well.

CarlCC
Copper Contributor
Dec 13, 2023
Any update Microsoft? I'd like to use PBI dataset instead of SSAS - this will likely keep me from doing so. PBI is good product, make it great by offering flexible options between PBI and Excel without introducing complexity to make it work. Thanks.
- oyasin
  Former Employee
  Jan 16, 2024
  
  For Analyze in Excel, only Power BI semantic models that use Import mode preserve hierarchies in the PivotTable Fields in the Excel workbook. Power BI semantic models that are built on DirectQuery or composite models don't retain their hierarchies when you use Analyze in Excel.
  
  https://learn.microsoft.com/en-us/power-bi/collaborate-share/service-analyze-in-excel#considerations-and-limitationshttps://learn.microsoft.com/en-us/power-bi/collaborate-share/service-analyze-in-excel#considerations-and-limitations