Looking for Starter Kits? Head to the Community Gallery! Now formatted as YXIs for easy installation.

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

Power BI Error

8 - Asteroid

I am trying to run a large workflow to create a Power BI file. The output is roughly 700 MB which is under the 1 GB threshold that Power BI allows. I am getting an error that says "Power BI API error... HTTP/1.1 429{"error":{code":"You are over your rows per hour limit for this dataset. Please retry your request later.""


Does anybody know what the rows per hour limit is? Does anyone know a workaround to get past this?


@bnelly1987 - https://docs.microsoft.com/en-us/power-bi/developer/api-rest-api-limitations


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
5 - Atom

Could you please explain what POST mean in "10,000 max rows per single POST rows request"? Thanks!

5 - Atom

Following - getting similar error and unsure the language in that response. Can I only post 10,000 rows in an output? That seems awfully low.