Power BI hierarchies missing when data model consumed in Excel

Senior Member

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 and directed me to post here.

 

If a Power BI model contains a DirectQuery or Dual mode table, and that same model also contains attribute hierarchies, those hierarchies are not accessible when the model is consumed through Excel.

 

Example:

Model with single table in import mode containing a hierarchy in Power BI Desktop

NicholasGross_7-1645644242754.png

 

Published model viewed from Excel. Hierarchy works fine in import mode!

NicholasGross_8-1645644292828.png

 

Model with single table in DirectQuery mode containing a hierarchy

NicholasGross_9-1645644311219.png

 

Hierarchy missing in Excel

NicholasGross_10-1645644321929.png

 

As we have many Excel users on our Power BI enterprise model and also rely on several hierarchies, this prevents us from optimizing our model with any type of aggregation or hybrid table. We are stuck with import on every table and cannot pursue any advanced refresh or query optimization strategies. 

 

 

1 Reply
same topic... is there any news?
thx Manuel