Forum Discussion

SHHargrove's avatar
SHHargrove
Icon for Advocate II rankAdvocate II
9 years ago

Hierarchies in Analyze in excel with Direct Query

Creating my first Direct Query Power BI report and testing Analyze in Excel.  I notice that none of my Hierarchies appear in Excel, even though they do when in Cached mode.  Have I done something wro...
Need Help
Anonymous's avatar
Anonymous
Not applicable
9 years ago

Hi SHHargrove,

 

>> I notice that none of my Hierarchies appear in Excel, even though they do when in Cached mode. 

Since I'm not very clear your issue, can you share some detail contents?

 

Regards,

Xiaoxin Sheng

SHHargrove's avatar
SHHargrove
Icon for Advocate II rankAdvocate II
9 years ago

 

In the images below, you'll see that the Product dimension in Power BI includes a "Products" hierarchy.  However in Excel (using Analyze in excel from the same Power BI dataset) the "Products" hierarchy does not appear.

 

Product Dimension in ExcelProduct Dimension in Power Bi

  • Anonymous's avatar
    Anonymous
    Not applicable
    9 years ago

    Hi SHHargrove,

     

    If you try to use the hierarchy which created at database, does it analysis in excel succeed? I think excel can't analysis the hierarchy columns which created in power bi.

     

    Regards,

    Xiaoxin Sheng

    • SHHargrove's avatar
      SHHargrove
      Icon for Advocate II rankAdvocate II
      9 years ago

       

      ExcelThis picture is from Analyze in Excel when not using Direct Query in Power BI.

      Clearly the difference is Direct Query.

       

      • Måns's avatar
        Måns
        Frequent Visitor
        6 years ago

         Was this ever resolved still seems to be the case. They only way to get Hierarchys to show up is to convert the entire model to Import mode. Even if all tables involved in the Hierarchy are moved to Import a single separate table in DQ mode kills the hierarchy from Excel Pivot fields.