Forum Discussion

asacero's avatar
asacero
New Member
7 months ago
Solved

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

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

Hi team,

I’m experiencing an issue when trying to refresh the dataset in Power BI Service. The refresh fails with the following error message:

“Something went wrong. COM error: mscorlib, A task was canceled.”

The strange part is that the dataset refreshes successfully in Power BI Desktop, and the process takes approximately 15 minutes. However, in Power BI Service the refresh does not complete and triggers the error above.

Could you please help me identify the cause and advise on how to resolve this issue?

Thank you in advance for your support.

Best regards,

Need Help
  • v-echaithra's avatar
    v-echaithra
    7 months ago

    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.

4 Replies

  • v-echaithra's avatar
    v-echaithra
    Community Support
    7 months ago

    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.

  • rohit1991's avatar
    rohit1991
    Super User
    7 months ago

    Hii asacero 

     

    You can try optimizing the model (reduce data volume, remove unused columns, simplify Power Query steps), enable incremental refresh if applicable, and make sure the dataset is on an appropriate capacity. If the issue persists, check the gateway logs (for on-prem sources) and consider raising a Microsoft support ticket, as this can also be a service-side timeout.

  • v-echaithra's avatar
    v-echaithra
    Community Support
    6 months ago

    Hi asacero ,

    I just wanted to check if the issue has been resolved on your end, or if you require any further assistance. Please feel free to let us know, we’re happy to help!


    Thank you 

  • v-echaithra's avatar
    v-echaithra
    Community Support
    6 months ago

    Hi asacero ,

    May I ask if you have resolved this issue? Please let us know if you have any further issues, we are happy to help.

    Thank you.