CODEWITHSUNDEEP
excelms-officeexport-to-csvpowerquerydata-cleaning
Akil Riaz
Akil Riaz

Reputation: 63

How to convert Microsoft ODC file/PowerQuery from Excel file with over 2 million rows of data to a CSV file?

I recently used PowerQuery to clean a dataset with over 2 million rows of data. How can I now save this cleaned dataset as a usable CSV file, not a query? I cannot load the query into excel and then save it as it contains over 2 million rows of data.

Can I save the data connection as a Microsoft ODC file, open it in Access and then save it as a CSV file? Or are there any other alternatives?

NOTE: Essentially my ultimate goal is to upload the dataset into Tableau (to visualize the data). So any solution that enables this would be preferred and appreciated.

Upvotes: 2

Views: 225

Answers (1)

davidebacci
davidebacci

Reputation: 30304

Use DAX Studio to export the table into CSV from the data model or PBI.

https://daxstudio.org/

Upvotes: 2

Related Questions