export data limit work around solution

[Anonymous]

Hi experts, is there any solution that if I can  export data without 150000 limit? Thank you.

[collinq]

Hey @Anonymous ,

Along with the ideas from @SaiTejaTalasila  you could use the direct connection of up to 500,000 rows.  But, there is no way to override the 150,000 if you want a direct export.

[SaiTejaTalasila · Accepted solution]

Hi,

This is a limitation when exporting data from a visual. Do you must export data from a visual? If not, you can export data from a table with an external tool DAX Studio. Export Data | DAX Studio

Using DAX Studio to Export Data From Power BI - UrBizEdge Limited

Or 

You can use power automate -run a query against a dataset action to pull the data.