Power BI :data extraction challenge

[vilenm]

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 or all limitations .

My concern with paginated reports is tabular model as the source. if the dataset is about for eg.500 000 rows the report takes way too long to render unless its very small.

Out of options or ideas any suggestions please advise?

[SivaMani]

@vilenm, You can try the below options,

1. Power BI REST API
   1. Export Power BI report to file - https://learn.microsoft.com/en-us/power-bi/developer/embedded/export-to
   2. Export paginated report to file - https://learn.microsoft.com/en-us/power-bi/developer/embedded/export-paginated-report
2. You can use the same APIs in Power Automate and integrate them with your Power BI report

I hope this helps!