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 not sure what you mean, it is working, see my last reply.

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

Power BI

Excel (Analyse in Excel)

 

  • v-zhenbw-msft's avatar
    v-zhenbw-msft
    Icon for Community Support rankCommunity 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's avatar
      markplace
      Icon for Helper I rankHelper I
      6 years ago

      Thanks. I unistalled and reinstalled the latest "analyse in excel". Still not seeing hierarchies.

       

       

      • v-zhenbw-msft's avatar
        v-zhenbw-msft
        Icon for Community Support rankCommunity Support
        6 years ago

        Hi markplace ,

         

        This is really strange. Sorry for that, We cannot reproduce the issue here and also not found an effective solution. 

        Now all we can do is suggest you open a Ticket : https://powerbi.microsoft.com/en-us/support/

        The best way is leting engineers solve the issue from your perspective.

         

        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.