Issue Updating Dataset in Power BI Service – COM Error: A Task Was Canceled

Hi asacero ,

In Power BI Service, this error typically indicates that the dataset refresh was forcibly terminated. The most common causes include:

Service timeout limitations
Memory constraints during refresh
On-premises data gateway limitations
Inefficient query execution within the Power BI Service environment

Try these troubleshooting and resolution Steps

1. Review Refresh History
Navigate to Power BI Service > Dataset > Refresh History and review the duration of the refresh before it fails
Whether any tables complete successfully before the failure occurs

2. Isolate the Problematic Table
In Power BI Desktop:

Disable refresh for approximately half of the tables
Publish the dataset > Trigger a refresh in Power BI Service > Repeat the process to identify the specific table causing the failure

3. Optimize Power Query Transformations
Ensure queries are optimized by:

Applying filters as early as possible
Avoiding the use of Table.Buffer
Preserving query folding

4. Enable Incremental Refresh for large datasets
If the dataset contains a large volume of historical data, enabling incremental refresh can significantly reduce refresh duration and memory usage.

Hope this helps.
Thank you.