Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

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

Power BI Error

bnelly1987
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?

3 REPLIES 3
JessieC
Alteryx
Alteryx

@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
Ychurc
6 - Meteoroid

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

briangeneration
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.

Labels