Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Due to consecutive errors, scheduled refresh has been disabled. Please resolve the error on the data

Over the weekend, my refresh was erroring out.  I was able to correct the underlying issue and do a successful manual refresh this morning, however, when I go in to reschedule my automatic refresh, I still see the error, "Due to consecutive errors, scheduled refresh has been disabled. Please resolve the error on the dataset and then re-enable."  I do not see anywhere that I have the option to re-enable the scheduled refresh.  Any help is appreciated.

  • Anonymous's avatar
    Anonymous
    3 years ago

    Hi  Anonymous ,

    It could be due to the following reasons:

    Your dataset refresh is disabled due to scheduled refresh will also get disabled automatically after four consecutive errors or two months of inactivity for the corresponding report of this dataset. This is as mentioned in this official document:

    Configure scheduled refresh - Power BI | Microsoft Learn

    To enable the dataset refresh, you can try to open the corresponding report of this dataset to make some visual interaction and use "Edit credential" to update the credential entered for this dataset to make a manual refresh to re-active the scheduled refresh for this dataset:

     

    Best Regards,

    Liu Yang

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

6 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable

    Hi  Anonymous ,

    It could be due to the following reasons:

    Your dataset refresh is disabled due to scheduled refresh will also get disabled automatically after four consecutive errors or two months of inactivity for the corresponding report of this dataset. This is as mentioned in this official document:

    Configure scheduled refresh - Power BI | Microsoft Learn

    To enable the dataset refresh, you can try to open the corresponding report of this dataset to make some visual interaction and use "Edit credential" to update the credential entered for this dataset to make a manual refresh to re-active the scheduled refresh for this dataset:

     

    Best Regards,

    Liu Yang

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

    • Anonymous's avatar
      Anonymous
      Not applicable

      Accepted solution may be too vague for those new to Power BI services and the Settings menu.

       

      Issue

      • Consecutive errors in a report can prompt scheduled refreshes to be "Disabled."
      • Although the error has been corrected, an error icon will still appear in the Power BI workspace refresh column and state that Refresh has been Disabled.
      • Rescheduling a Refresh is grayed out in the settings.

       

      Solution / How to Enable Fresh

       

      In Settings

      Expand "Data Source Credentials"

       

      The connection type will show an error icon.

      Click on the "Edit credentials" link

      Sign in to reconnect the source credentials.

       

       

       

      In the upper right of the Power BI Settings window, a notification will appear (and disappear quickly) that the Data Source has been updated.

       

      Refresh the Settings window in the browser

      Expand "Refresh"

      Set to "On"

       

       

      The Semantic model error will have gone away and the report is not set to refresh once again.

       

      • yaqub5's avatar
        yaqub5
        New Member

        Thanks for this solution,

        But i cant edit the credentials , as its showing no edit fields 

        Thanks in Advance

  • Anonymous's avatar
    Anonymous
    Not applicable

    I have followed your steps but still facing this error 

     

  • sjschminke3's avatar
    sjschminke3
    Frequent Visitor

    But why would it error if I have full access and can refresh manually through Power BI Service?  Why doesn't it refresh automatically?

  • For me I previously had schdeuled refresh 8+ times a day and then suddenly recieved this error after when I buggered up my query. After correcting my model i still had the error and could nt execute scheduled refresh any longer. After setting ≤8 refreshed per day it accepted the value and was working again.