CODEWITHSUNDEEP
powerbi
Koushik Chandra
Koushik Chandra

Reputation: 1491

Analyze in Excel from Power BI not showing hierarchies

I am using Snowflake as my backend database and created & published a dataset in Power BI with direct query. As a next step I am trying to analyze the data (to get Pivot experience) in excel.

I am observing the hierarchies I have created are not showing up in excel, though those are showing when accessing through PBI Service.

Upvotes: 0

Views: 464

Answers (1)

Dani U
Dani U

Reputation: 434

DirectQuery comes with a slew of limitations compared to imported datasets. The only hierarchy-specific limitation included in the official documentation is that Auto date-time hierarchies are not created for DQ datasets. However, this documentation is about direct limitations and doesn't specifically cover limitations that might only be applied to XMLA connections, which your connection from Excel is.

A workaround is to just use computed columns with the hierarchy values and name them like Category01, Category02, Category03 and do the nesting yourself. Users often have use cases that involve using hierarchies out of order (like grouping by Category03 THEN by Category01) and so consider it a feature rather than a flaw.

Upvotes: 1

Related Questions