Forum Discussion

Recoba88's avatar
Recoba88
Helper III
9 years ago
Solved

Export to csv from Power Query

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...
Need Help
  • hohlick's avatar
    hohlick
    9 years ago

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

OpenDataLab's avatar
OpenDataLab
Helper II
9 years ago

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's avatar
hohlick
Continued Contributor
9 years ago

Hi OpenDataLab, Recoba88

More correct syntax is

 

EVALUATE TableName

 

(no brackets)

    • hohlick's avatar
      hohlick
      Continued Contributor
      9 years ago

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

      • GarrettU's avatar
        GarrettU
        New Member
        8 years ago

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

         

        EDIT: I see this is in daxstudio, nevermind