Bad Request Error with the PowerBI Output Tool

[Loredana]

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

• Microsoft | Power BI | Push datasets limitations
• TPM-522:Error:“Bad request syntax or unsupported method” occurs if null values are found in the Inte...