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. 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...
BI & Data Analysis
excel
power bi
User Adoption
ovidiubaciu's avatar
ovidiubaciu
Copper Contributor
Mar 23, 2023

gisn 

I am going off on a tangent here: with the dataset published in import mode, were you able to actually use the hierarchy in Excel? When I connect to such a dataset, I can see the hierarchy (just like in your screen capture), but when I go ahead and actually try selecting it, an error dialog pops up.

  • ManuelK's avatar
    ManuelK
    Copper Contributor
    Mar 23, 2023

    ovidiubaciuIf I open Excel with models that use only import mode I can work with hierarchies otherwise they just don't go DIrect Query/Dual

Resources