Get certified for free when you join Fabric Data Days 2026 and dive into Fabric, Power BI, SQL, AI, and other essential data skills.
Join nowData Days is here! Join us now for 60+ days of learning, challenges, and connection. Learn more
I have a master table I have partitioned into a list of tables in Power Query. I would now like to export the tables into either seperate excel workbooks (preferred) or a workbook with each sheet being a table.
Is this possible to automate with an expression or some creative work around?
Hi @RossTheBoss ,
It seems that your situation is in Excel. I'm not faimilar that in excel.
You'd better post your requirement here to get the most professional help.
If you still have problems with Power BI, please feel free to ask.
Best Regards,
Cherry
Don't miss out on Data Days, June 15 through August 7. Learn Fabric, Power BI, SQL, AI and more.
Check out the May 2026 Power BI update to learn about new features.
| User | Count |
|---|---|
| 4 | |
| 4 | |
| 3 | |
| 2 | |
| 1 |
| User | Count |
|---|---|
| 11 | |
| 11 | |
| 5 | |
| 4 | |
| 3 |