Search code examples
powerbipowerquerym

Export million rows table from Power BI overcome the limit of 150k rows

Is there a way to overcome the Power BI export max limit of 150k rows?

Limit docs:
https://learn.microsoft.com/en-us/power-bi/visuals/power-bi-visualization-export-data#limitations-and-considerations

Voting for PBI improvement:
https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/18432742-increase-export-data-limits

Solution

  • It is possible to export a table of millions of rows from Power BI Desktop to a local disk with the help of Daxstudio.

    enter image description here

    Change the output to file:

    enter image description here

    And run the following code:

    EVALUATE
'MyTable'

    enter image description here

    And save the file in the desired output.

    enter image description here

    You will see the progress as the table is being dumped to disk.