Forum Discussion
Missing Hierarchies
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 regardsDenisBlog: WhatTheFact.biFollow me: twitter.com/DenSelimovic
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.