undefined

[Manjula]

Hi All,

How to export the report data from power bi workspace which has more than one million records.

I tried to export but i see there is limitations that only 1.50 lakhs records we can export into excel and CSV only one lakh records.

Regards,

Manjula

[v-yangliu-msft · Accepted solution]

Hi  @Manjula ,

You can use DAX Studio external tools to export the data to the entire model:

https://xxlbi.com/blog/dax-studio-export-all-data/

https://daxstudio.org/

This is the related document, you can view this content:

https://stackoverflow.com/questions/51375021/export-data-from-power-bi-to-sql-server-overcome-the-li...

https://community.powerbi.com/t5/Desktop/Exporting-a-table-with-over-1-million-rows/td-p/1160327

https://community.powerbi.com/t5/Desktop/Exporting-a-large-number-of-rows-from-Power-BI-to-Excel-or-...

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[arvindsingh802]

You should use analyse in excel option, that will allow to have all data in excel and do additional analysis

Analyze in Excel for Power BI - Power BI | Microsoft Docs

If this post helps, then please consider Accept it as the solution, Appreciate your Kudos!