Alteryx Designer Knowledge Base

Definitive answers from Designer experts.

Failed to create dataset 400 Bad request - PowerBI Output Tool

Loredana
Alteryx
Alteryx
Created

Environment Details


  • Alteryx Designer
    • 2018.3+
  • PowerBI Output Tool
    • All versions


Cause


  • PowerBi Tool has limitation based on Microsoft provided functionality.
  • Workflows displays 400 Bad Request when usage parameters go over the limits.


Resolution


Modify workflow to respect the limitation of PowerBi.
 

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
https://docs.microsoft.com/en-us/power-bi/developer/automation/api-rest-api-limitations
 
No ratings