Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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...
Solved! Go to 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.
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.
User | Count |
---|---|
102 | |
91 | |
84 | |
77 | |
71 |
User | Count |
---|---|
113 | |
104 | |
100 | |
73 | |
65 |