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
- PowerBI Output Tool
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