Forum Discussion

gisn's avatar
gisn
Copper Contributor
Feb 23, 2022

Power BI hierarchies missing when data model consumed in Excel

I posted this issue in the Power BI forums. Power BI hierarchies missing when data model consu... - Microsoft Power BI Community After internal review, the Power BI team said this is an Excel issue...
BI & Data Analysis
excel
power bi
User Adoption
CarlCC's avatar
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's avatar
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


Resources