Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!Vote for your favorite vizzies from the Power BI Dataviz World Championship submissions. Vote now!
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
Vote for your favorite vizzies from the Power BI World Championship submissions!
If you love stickers, then you will definitely want to check out our Community Sticker Challenge!
Check out the January 2026 Power BI update to learn about new features.
| User | Count |
|---|---|
| 12 | |
| 11 | |
| 7 | |
| 7 | |
| 6 |