PowerBI Overview

WORK IN PROGRESS

Push datasets limitations

Limitations

• 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
• 75 max relationships
• Doesn't work with service principal profiles

Ref: https://learn.microsoft.com/en-us/power-bi/developer/embedded/push-datasets-limitations