How to export data in power bi when set of tables are grouped

[GVenkatesh]

In power bi report I have grouped 3 tables now I need to export whole set of tables data insteed I am getting only the data of top first table 

please let me know if there is any other way to help

[Anonymous]

Hi @GVenkatesh 

Do you mean you want to extract data from all three tables, but now you only extract data from one table? Can you provide some sample data or a more detailed description? Based on your description, I don't quite understand what you expect.

Best Regards!

Yolo Zhu

[GVenkatesh]

Hi @Anonymous 
Below is the link of pbix file without sensitive data
https://drive.google.com/file/d/1YiMw9tsmyvcKsrYvjz6Ks4tLW4jXn5Zq/view?usp=sharing

I need to export whole set of tables data with a single click of export option after grouping of tables
please review the above file let me know the solution

[Anonymous]

Hi @GVenkatesh 

Your data comes from three different table visuals, so you cannot export the data at once, even though you have combined the three visuals. The purpose of grouping visual is to allow you to move them more conveniently in the report, or to set conditional formats uniformly, but it does not have the function of exporting all the grouped tables, it can only export them one by one. .

Group visuals in Power BI Desktop reports - Power BI | Microsoft Learn

If you want to export at once, you need to put all the fields in the same table visual. The best way is to export the data from the three visuals separately and then merge them into one Excel file.

The result of the merging of the three tables:

Best Regards!

Yolo Zhu

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

[Kedar_Pande]

Please share a simplified version of your PBIX file (in English) without sensitive data. You can upload it to a public cloud service like OneDrive, Google Drive, or Dropbox and share the link. This will help in understanding your data structure and the issue, allowing for more precise guidance.

[GVenkatesh]

Hi @Kedar_Pande 
Below is the link of pbix file without sensitive data
https://drive.google.com/file/d/1YiMw9tsmyvcKsrYvjz6Ks4tLW4jXn5Zq/view?usp=sharing

I need to export whole set of tables data with a single click of export option after grouping of tables
please review the above file let me know the solution