Forum Discussion
Unable to Export Data from PBI server report
Yes, it may be possible using Power Automate. This would also provide the ability to extract all 4 tables to a file with one button click. The trick to get pass the row limit in Power Automate Connector is split the DAX into chunks (a bit like an API call pagination). Try the following as a guide.
Export MORE THAN 100k rows of Power BI data to CSV using Power Automate | No ROW limits! - YouTube
Create a new Excel File in Power Automate and dynamically populate with a Table and Rows #Excel - YouTube
Hi Anonymous - the only thing that comes to mind is data limit of 30k / 150k, but I would expect a different error message. Can we use the export when the table has a limited number of rows?
You´re right, it seems that maximum limit of exported rows is 150K - https://learn.microsoft.com/en-us/power-bi/visuals/power-bi-visualization-export-data?tabs=powerbi-desktop. 😞 Do you have any idea how to outwit it?