Push semantic model limitations

This article lists limitations of the Power BI REST APIs Push semantic models.

Limitations

Review the following list of limitations before using the push semantic models APIs.

  • 75 max columns

  • 75 max tables

  • 10,000 max rows per single POST rows request

  • 1,000,000 rows added per hour per semantic model

  • 5 max pending POST rows requests per semantic model

  • 120 POST rows requests per minute per semantic model

  • If table has 250,000 or more rows, 120 POST rows requests per hour per semantic model

  • 200,000 max rows stored per table in FIFO semantic model

  • 5,000,000 max rows stored per table in 'none retention policy' semantic model

  • 4,000 characters per value for string column in POST rows operation

  • 75 max relationships

  • Doesn't work with service principal profiles