Forum Discussion

Helper I

4 years ago

Solved

undefined

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 exp...

Anonymous
4 years ago
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-limit-of-150k-rows

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-CSV/m-p/953627

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.

Community Champion

4 years ago

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!

Related content