Export to csv from Power Query

[Recoba88]

Hi,

How can I export to csv, data with 3 million rows from power query (excel not powerbi desktop)

If you know the way to load to powerdesktop this data and export from there it also can help

Thanks!

[OpenDataLab]

Try using Dax Studio. https://daxstudio.codeplex.com

You can write a query against you Power BI data model to extract the data and it has the option to output to file.

The syntax to query a single table in your model would be:

EVALUATE [TableName]

Let me know how you get on.

[hohlick]

Hi @OpenDataLab, @Recoba88

More correct syntax is

EVALUATE TableName

(no brackets)

[Recoba88]

HI.

I did what you say

How can I export  - attached image - where I need to press?

http://imgur.com/a/OePSF

[hohlick · Accepted solution]

4th button on the ribbon ("Output") - press the small triangle under the button and select File. Then press F5.

[GarrettU]

I am in powerbi using power query, does this button exist there?

EDIT: I see this is in daxstudio, nevermind

[Recoba88]

THANKS!