how to save data to a local file within a step ?

[Anonymous]

Hello,

I wanted to know If I can, within a step of a query, export/Save my table/list to an local file ? Is there such a M method ?

[Anonymous · Accepted solution]

I've found my answer : Table.ToCSV(...)

[ToddChitt]

I don't think so. Investigate Power Apps and Flow.

[ams1]

Hi,

Excel PowerQuery or PowerBI PowerQuery (Desktop or server)?

https://community.powerbi.com/t5/Power-Query/Can-PowerQuery-write-data-back-out/td-p/1288

[ams1]

For many quick and dirty tricks (especially in Excel PowerQuery) I personally start a local webserver, pass the data to it and do things there.

I prefer python, but there is also a 10 lines of code PowerShell local webserver I sometimes use.

So: PQ - local webserver - disk