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

Hello, 

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

1 Reply

@learner1234 

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.