Forum Discussion

Anonymous

Not applicable

7 years ago

Solved

How to Export Query in Power BI Desktop as CSV

Hello Community, Can someone let me know how to export a query generated from the Query Editor to a CSV file? Thanks Carlton

v-danhe-msft
7 years ago
Hi Anonymous,

Based on my research, in query editor, there is not a function to output a csv file in Power BI, I suggest you to try below solutions:

1.You could copy the table you want to export in data view after you have applied your queries.

Reference:https://community.powerbi.com/t5/Desktop/How-to-export-some-huge-query-results-in-excel/td-p/200084

2.You could use the Dax Studio to export the file you want.

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

Regards,

Daniel He

Microsoft Employee

7 years ago

Hi Anonymous,

Based on my research, in query editor, there is not a function to output a csv file in Power BI, I suggest you to try below solutions:

1.You could copy the table you want to export in data view after you have applied your queries.

Reference:https://community.powerbi.com/t5/Desktop/How-to-export-some-huge-query-results-in-excel/td-p/200084

2.You could use the Dax Studio to export the file you want.

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

Regards,

Daniel He