How to import powerbi hierarchies into excel

[naveenam]

We have a requirement that we need to import powerbi hierarchies into excel. For example Date Hierarchy, in powerbi we auto create date hierarchy like year, quarter, month.

When the powerbi dataset is imported to excel, the date hierarchy which is created in powerbi desktop, is not importing in excel.

Please suggest how to achieve the above requirement.

[v-kkf-msft]

Hi @naveenam ,

I am not sure if I understood your question correctly. If you export the visual data as excel file, then it will retain the hierarchy.
If you use excel to connect to the dataset, you will need recreate the hierarchy in Excel as the date hierarchy is a PowerBI specific feature.

Hierarchies in Power Pivot 

Best Regards,
Winniz
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.