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.

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

Hi, MDekker 

 

What would the output of the four files look like in your expectation? Is it all as shown in the screenshot?

 

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.