1000 lines export limitation of Power BI, Exporting through Power automate

[Rushik]

I have created Power automate flow and trying export more than 1000 rows of data from Power BI to Sharepoint. But I am not able export more than 1000 rows. Power BI only give 1000 rows of data after that other data is neglecting.

My flow is working welll with other dataset and has no limitation on no rows.

I have tried 'Run Query Against dataset' Power Bi connector but this not suitable for my application

[christinepayton]

There is a setting in a lot of Power Automate actions (ellipsis menu ->settings) that allows you to enable pagination and increase the threshold. If you do this, then set it above the number you need, it should work. There are upper limits on all the connectors though.