Forum Discussion

MDekker's avatar
MDekker
Regular Visitor
3 years ago
Solved

How to burst to Excel

Hi all. i have a report like the screenshot. No RLS, just a simple table. I run it as administrator.  I need to export this into separate Excel files, separated on Country.  So with the above...
Need Help
Show and Tell
Tips and Tricks
  • v-zhangti's avatar
    v-zhangti
    3 years ago

    Hi, MDekker 

     

    You can try the following methods.
    In the Power Query, select the Region and Country columns and select Group by.

    Result1:

    Then copy the table in 4 copies.

    Each table expands one Table.

    Is this the result you expect?

     

    Best Regards,

    Community Support Team _Charlotte

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

MDekker's avatar
MDekker
Regular Visitor
3 years ago

Hello, v-zhangti!
For the Netherlands file, it would only contain two records. Like

The Belgium file will have 2 records, the USA file just one, just like Mexico.

In total i expect about 140 files, each with a portion of the data.
In the above example I used Regio and Country just for sake of clarity. The actual report will contain sales regions and locations, but that 'behaves' in a similar way as the example show here.

regards, Marco

  • v-zhangti's avatar
    v-zhangti
    Icon for Community Support rankCommunity Support
    3 years ago

    Hi, MDekker 

     

    You can try the following methods.
    In the Power Query, select the Region and Country columns and select Group by.

    Result1:

    Then copy the table in 4 copies.

    Each table expands one Table.

    Is this the result you expect?

     

    Best Regards,

    Community Support Team _Charlotte

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