Forum Discussion

Helper 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
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

Helper I

6 years ago

I hope that's not the case. We're transitioning from on-prem SSAS tabular to Power BI and told our customer "it's going to be better". Now I have to tell them "well, not so much".

parry2k

Super User

6 years ago

markplace not sure what you mean, it is working, see my last reply.

markplace
Helper I
6 years ago
Power BI
Excel (Analyse in Excel)
- v-zhenbw-msft
  Community Support
  6 years ago
  Hi markplace ,
  
  Sorry for that we have a test and there is a Hierarchy in Excel.
  
  We suggest you can uninstall the Analyze in Excel feature and download the latest update Analyze in Excel, then try again.
  
  Also you can refer this Requirements.
  
  If it doesn’t meet your requirement, we suggest you to open a ticket here for help if you are a pro user: https://powerbi.microsoft.com/en-us/support/
  
  Best regards,
  
  Community Support Team _ zhenbw
  If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
  - markplace
    Helper I
    6 years ago
    Thanks. I unistalled and reinstalled the latest "analyse in excel". Still not seeing hierarchies.