Capable of exporting and replicating the drill down/hierarchy of a report into an excel

[SaiDarsi]

Hi,

Is there any way to keep drill down/hierarchy in excel while exporting from the Power Bi Service?

In Masterstrategy that feature is available I am giving the link for reference : KB44108: When outline mode is enabled on a grid on a report services document, data is missing in so...

[v-yadongf-msft · Accepted solution]

Hi @SaiDarsi ,

When you select "export data" in Power BI service, there are three modes: Date with current layout, Summarized data, Underlying data.

If you want to keep drill down/hierarchy in excel, I suggest you select "Data with current layout".

Data in service:

Export to excel:

For more information, please refer to: Export data from a Power BI visualization - Power BI | Microsoft Learn

Best regards,

Yadong Fang

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