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. ğŸ˜±

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.