Limitations in "add rows", API Rest

I am afraid not.

The Power BI API limits is documentated in the following site:

Power BI REST API Limits

https://msdn.microsoft.com/en-us/library/dn950053.aspx

"

To POST Rows

• 75 max columns
• 75 max tables
• 10,000 max rows per single POST rows request
• 1,000,000 rows added per hour per dataset
• 5 max pending POST rows requests per dataset
• 120 POST rows requests per minute per dataset
• If table has 250,000 or more rows, 120 POST rows requests per hour per dataset
• 200,000 max rows stored per table in FIFO dataset
• 5,000,000 max rows stored per table in ‘none retention policy’ dataset
• 4,000 characters per value for string column in POST rows operation

"

What do you mean for " migration purposes"?

please consider to sub the rows into two post actions if one is not able to finish the process.

Or you may rise a support ticket to see if there are any further workaorunds to overcome the REST API limits.

https://powerbi.microsoft.com/en-us/support/

Regards,

Michael