Forum Discussion

Kari551's avatar
Kari551
New Member
1 year ago
Solved

Issue with report refresh

Hi everyone!

We're facing some issues with Power BI report refresh in Power BI Service. Each time after refresh (both manual and scheduled), we're receiving the following error: "COM error: mscorlib, A task was cancelled.. Table: <table_name>". A table name is different after each refresh.

Has anyone faced a similar issue and/or can provide a suggestion to resolve the problem?

 

Thank you in advance!

Need Help
  • v-venuppu's avatar
    v-venuppu
    1 year ago

    Hi Kari551 ,

    Have you checked on the suggested points like Timeout and Capacity Resources..?If not please have a look at them as it might help you to solve the issue.

    Thank you.

9 Replies

  • Thomaslleblanc's avatar
    Thomaslleblanc
    Super User
    1 year ago

    check the source data service to see if there are any timeout issues happening.

    Or see if the resources availble in your workspace/capacity are maxed out

    • Kari551's avatar
      Kari551
      New Member
      1 year ago

      Thank you for your suggestion!

      Could you please clarify where these options can be found?

  • v-venuppu's avatar
    v-venuppu
    Community Support
    1 year ago

    Hi Kari551 ,

    Thank you for reaching out to Microsoft Fabric Community.

    Thank you Thomaslleblanc for the prompt response.

    1.Source Data Timeout

    Open your report in Power BI Desktop.
    Use Performance Analyzer to check query duration.
    If using a gateway, go to Power BI Service > Manage Gateways and review logs for timeouts.

     2.Workspace/Capacity Resources

    If you are on Premium or PPU, go to Power BI Service > Admin Portal > Capacity Settings.
    Use the Capacity Metrics app to monitor memory, CPU, and refresh queues.

    If you're on shared capacity, try refreshing during off-peak hours or reduce dataset complexity.

    Thank you.

  • Thomaslleblanc's avatar
    Thomaslleblanc
    Super User
    1 year ago

    If you source system is SQL Server, then have a database administrator look at the SQL Server Error logs around the time the refresh failed. Look for 'timeout' in the text filter

  • v-venuppu's avatar
    v-venuppu
    Community Support
    1 year ago

    Hi Kari551 ,

    I wanted to check if you had the opportunity to review the information provided and resolve the issue..?Please let us know if you need any further assistance.We are happy to help.

    Thank you.

  • v-venuppu's avatar
    v-venuppu
    Community Support
    1 year ago

    Hi Kari551 ,

    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.

  • v-venuppu's avatar
    v-venuppu
    Community Support
    1 year ago

    Hi Kari551 ,

    Have you checked on the suggested points like Timeout and Capacity Resources..?If not please have a look at them as it might help you to solve the issue.

    Thank you.

  • v-venuppu's avatar
    v-venuppu
    Community Support
    1 year ago

    Hi Kari551 ,

    May I ask if you have resolved this issue?If not can you let us know the status on the suggested points, so that it will be helpful for us to solve the issue.

    Thank you.