[FIXED] How can I export power query data from excel into a csv with built-in tools?

Issue

I am trying to export a large amount of data from an ETL operation in excel for later queries.

In order to do so I need the data in a csv.

However, excel does not allow more than 1 million rows to exist in a table.

How can I work around this limitation?

Solution

Use DAX Studio to export to csv. It's a free tool.

Answered By - David

Answer Checked By - David Goodson (PHPFixing Volunteer)