cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
DaHolla
Frequent Visitor

Missing Hierarchies

Can someone explain why my hierarchies in Power BI Desktop show up, but they disappear when connecting to the same dataset via Excel?

DaHolla_0-1626215663726.png

DaHolla_1-1626215713484.png

 

 

1 ACCEPTED SOLUTION

Hey @DaHolla ,

 

I know it doesn't work for direct query for sure. In composite mode it might be that technically it won't work in general even if the table with the hierarchy is in import mode.

You could try to do the same in import mode for the whole model. If it works, we know that for composite model the behavior in Excel is similar to direct query.

 

If you need any help please let me know.
If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍
 
Best regards
Denis
 

View solution in original post

3 REPLIES 3
selimovd
Super User
Super User

Hey @DaHolla ,

 

I guess you are using direct query?

In direct query the hierarchies are not supported in Excel. If you switch to import mode they should appear also in Excel.

 

If you need any help please let me know.
If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍
 
Best regards
Denis
 
DaHolla
Frequent Visitor

Hello @selimovd,

Thank you for the quick reply!

The dataset uses some direct query tables that utilize aggregate tables, the OrderMethod table is a dual table. Other tables in the dataset, which are import, also do not have their hierarchies show up in Excel.

Hey @DaHolla ,

 

I know it doesn't work for direct query for sure. In composite mode it might be that technically it won't work in general even if the table with the hierarchy is in import mode.

You could try to do the same in import mode for the whole model. If it works, we know that for composite model the behavior in Excel is similar to direct query.

 

If you need any help please let me know.
If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍
 
Best regards
Denis
 

View solution in original post

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

November Power BI Update 768x460.png

Check it Out!

Click here to read more about the November 2021 Updates!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.