Alteryx Designer Knowledge Base

Definitive answers from Designer experts.

Failed to create dataset 400 Bad request - PowerBI Output Tool


Environment Details

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


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


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
No ratings