Alteryx Designer Knowledge Base

Definitive answers from Designer experts.

Bad Request Error with the PowerBI Output Tool

Loredana
Alteryx Alumni (Retired)
Created

Issue

Worklows using the Power BI Output tool may fail with either of the following errors: 
 
Failed to create dataset <dataset name>. 400: Bad Request
Bad request syntax or unsupported method. Dataset must contain at least one table. 

Environment Details

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


Cause

  • PowerBi Tool has limitations based on Microsoft provided functionality.
  • Workflows display a Bad Request error when usage parameters go over these 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


Additional Resources