Copilot for Microsoft 365 Tech Accelerator
Feb 28 2024 07:00 AM - Feb 29 2024 10:30 AM (PST)
Microsoft Tech Community

PowerQuery M: Automate Export to plain XLSX (without connections)

Copper Contributor


is there a Excel PowerQuery M command that allows to export a table as XLSX without any connections? Thank you!

1 Reply


Nope, Power Query exports nothings, it loads the result into current workbook grid or keeps connection only. You may consider the option of Power Automate + OfficeScript.