Forum Discussion

BI2B's avatar
BI2B
Frequent Visitor
8 years ago

Hierarchy date in Pivot Tables Excel (Power BI Publisher or Analyze in Excel)

Hi,   I have no problem with creating hierarchies in .pbix (direct query).   But when I use a connection through an excel (Power BI Publisher or Analyze in Excel), I do not see the hierarchies I ...
Need Help
Anonymous's avatar
Anonymous
Not applicable
8 years ago

BI2B,

This could be a limitation of DirectQuery, when I use Import mode to connect to the data source and use "Analyze in Excel", hierarchies are available in Excel.

Regards,
Lydia

BI2B's avatar
BI2B
Frequent Visitor
8 years ago

Thank you, Lydia

But I need a Direct Query mode only

  • Claster's avatar
    Claster
    Icon for Advocate II rankAdvocate II
    6 years ago

    The same......Did you find the solution?