How to Export More Than 1000 Rows from a Power BI Report to a CSV File in Power Automate?
Question: I'm currently working on a Power Automate flow where I need to export data from a Power BI report to a CSV file. However, I'm encountering a limitation where only 1000 rows of data are being exported. Is there a way to export more than 1000 rows from a Power BI report into a CSV file using Power Automate? Details: I have a Power BI report that contains more than 1000 rows of data. I've set up a Power Automate flow to export data from this report to a CSV file. However, I'm only able to export 1000 rows of data at a time. Is there a workaround or configuration setting that allows me to export more than 1000 rows from the Power BI report? Additional Information: I've checked the export settings in Power BI but couldn't find any options to increase the row limit for CSV exports. I'm open to using any alternative methods or connectors if needed to achieve this requirement. Any guidance or suggestions would be greatly appreciated! please help to solve : (
