Edit

Push datasets limitations

  • Article
  • 2 minutes to read

Push datasets are very limited in their functionality. They're designed only for a near real-time streaming scenario to be consumed by a streaming tile in a dashboard, and not by a Power BI report.
This article lists limitations of the Power BI REST APIs push datasets.

Limitations

Review the following list of limitations before using the push datasets APIs.

  • 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

Next steps