Forum Discussion
Load query result in several sheets (Power Query Excel)
Hi pmaurizi
To my knowledge, Power Query is not a good tool to do this task. In Power Query, queries cannot be created automatically or dynamically according to a dynamic value from another query. The queries are pre-defined by you, so the number of queries is fixed. The number cannot be changed according to the data change in a single query.
I found some articles about using Python or Power Automate to complete this task. Hope they will be helpful:
How To Split An Excel File Into Multiple Files Using Python - Python In Office
Solved: Split an Excel file into several sheets - Power Platform Community (microsoft.com)
How to Export filtered data to Excel from Power BI... - Power Platform Community (microsoft.com)
Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.
Hi pmaurizi
To my knowledge, Power Query is not a good tool to do this task. In Power Query, queries cannot be created automatically or dynamically according to a dynamic value from another query. The queries are pre-defined by you, so the number of queries is fixed. The number cannot be changed according to the data change in a single query.
I found some articles about using Python or Power Automate to complete this task. Hope they will be helpful:
How To Split An Excel File Into Multiple Files Using Python - Python In Office
Solved: Split an Excel file into several sheets - Power Platform Community (microsoft.com)
How to Export filtered data to Excel from Power BI... - Power Platform Community (microsoft.com)
Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.