Forum Discussion

markplace's avatar
markplace
Icon for Helper I rankHelper I
6 years ago
Solved

Using Power BI Hierarchies in Excel

My Power BI model contains several Hierarchies.  They work as expected in Power BI.   However when I view my model in Excel they are missing.   Am I doing something wrong?
Need Help
  • markplace's avatar
    markplace
    6 years ago

    In case anyone is interested, we've traced this problem down to the fact that I'm using a composite model.

     

    Hiearchies show up fine in Excel as long as you import.  Mixing import and direct query is a fail when it comes to hierarchies in Excel. ðŸ˜±

markplace's avatar
markplace
Icon for Helper I rankHelper I
6 years ago

In case anyone is interested, we've traced this problem down to the fact that I'm using a composite model.

 

Hiearchies show up fine in Excel as long as you import.  Mixing import and direct query is a fail when it comes to hierarchies in Excel. ðŸ˜±

parry2k's avatar
parry2k
Icon for Super User rankSuper User
6 years ago

markplace oh wow! Who would have think of that? Good to know. Thanks for sharing your finding, and I'm sure many users will find it helpful, well done.

  • markplace's avatar
    markplace
    Icon for Helper I rankHelper I
    6 years ago

    Actually I found that it is a "benefit" of using Direct Query.  Anything other than import will bork your hierarchies in Excel.