Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Panels update failed

Hello everyone,

 

The error below occurs frequently when updating my dashboards, how can I fix this?

 

Thank you.

 

  • As you can see from the error message that is an issue on your data source, not on Power BI.

     

    Probably you have lots of activities on your data source table(s) that result in table locks or row locks. Lots of writing, inserts, updates, deletes etc.

     

    Find a different timing for your refreshes, maybe?

  • Hi Anonymous ,

     

    You may upgrade the Power BI Desktop to the latest version 2.81.5831.1181 , then republish the pbix file to Power BI Service again.

     

    Or you may remove the broken reports from the Online service and re-add them, as described in the similar case: Refresh Failed - Internal Service Error .

     

    1 - Open the report(s) in PBI Desktop and clear the cache (file...options and settings... options)

    2 - Refresh the data in the desktop and save.

    3 - Open PBI Online and remove the associated dataset(s). Note - you'll need to remove the reports from any content packs before you can remove the reports and data from the online service. Also you might want to make a note of the (failed) refresh schedule you had before doing this so you can recreate it exactly.

    4 - Hop back to PBI Desktop and publish the report from PBI Desktop to Online

    5 - Hop back to PBI Online and set the refresh schedule back up

    6 - Add the reports back into any apps or content packs.

     

    Best Regards,

    Amy 

     

    Community Support Team _ Amy

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

2 Replies

  • As you can see from the error message that is an issue on your data source, not on Power BI.

     

    Probably you have lots of activities on your data source table(s) that result in table locks or row locks. Lots of writing, inserts, updates, deletes etc.

     

    Find a different timing for your refreshes, maybe?

  • v-xicai's avatar
    v-xicai
    Community Support

    Hi Anonymous ,

     

    You may upgrade the Power BI Desktop to the latest version 2.81.5831.1181 , then republish the pbix file to Power BI Service again.

     

    Or you may remove the broken reports from the Online service and re-add them, as described in the similar case: Refresh Failed - Internal Service Error .

     

    1 - Open the report(s) in PBI Desktop and clear the cache (file...options and settings... options)

    2 - Refresh the data in the desktop and save.

    3 - Open PBI Online and remove the associated dataset(s). Note - you'll need to remove the reports from any content packs before you can remove the reports and data from the online service. Also you might want to make a note of the (failed) refresh schedule you had before doing this so you can recreate it exactly.

    4 - Hop back to PBI Desktop and publish the report from PBI Desktop to Online

    5 - Hop back to PBI Online and set the refresh schedule back up

    6 - Add the reports back into any apps or content packs.

     

    Best Regards,

    Amy 

     

    Community Support Team _ Amy

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.