Forum Discussion
vilenm
Helper II
Helper IIPower BI :data extraction challenge
Hi So we know that power bi has limitation of exporting 150K rows of data and power automate button can load 30k rows of data. Our users requirement to be able to extract report data is > than 150K...
SivaMani
Resident Rockstar
Resident Rockstarvilenm, You can try the below options,
- Power BI REST API
- Export Power BI report to file - https://learn.microsoft.com/en-us/power-bi/developer/embedded/export-to
- Export paginated report to file - https://learn.microsoft.com/en-us/power-bi/developer/embedded/export-paginated-report
- You can use the same APIs in Power Automate and integrate them with your Power BI report
I hope this helps!