Showing results for 
Search instead for 
Did you mean: 
Helper V
Helper V

Power Query M Export output to txt file



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.


Solution Sage
Solution Sage

Hi @nirrobi,


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


Let us know if it does not work...



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


Helpful resources

PBI Sept Update Carousel

Power BI September 2023 Update

Take a look at the September 2023 Power BI update to learn more.

Learn Live

Learn Live: Event Series

Join Microsoft Reactor and learn from developers.

Dashboard in a day with date

Exclusive opportunity for Women!

Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!

MPPC 2023 PBI Carousel

Power Platform Conference-Power BI and Fabric Sessions

Join us Oct 1 - 6 in Las Vegas for the Microsoft Power Platform Conference.

Top Solution Authors