Power Query M Export output to txt file

[nirrobi]

Hi,

Is there a way to export the out of PQ/M directly to txt file?

Today I can achieve it with VBA but prefer to skip the VBA if possible.

Thanks in advanced.

Nir

[Interkoubess]

Hi @nirrobi,

If you are using Dax Studio then you have the option as below:

http://community.powerbi.com/t5/Desktop/Export-to-csv-from-Power-Query/td-p/193423

Let us know if it does not work...

Ninter

[nirrobi]

Hi @Interkoubess thanks for your mesage.

I fimiliar with the dax studio option but I want more automatic procedure.

for example , everyday txt file (base on the logic of PQ)  will be generate to spesific folder