Forum Discussion
export data limit work around solution
Hi experts, is there any solution that if I can export data without 150000 limit? Thank you.
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.
2 Replies
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.
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.
