Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
1 year ago
Solved

An error occurred while processing the data in the semantic model.

Hi, I need some assistance I have about five reports that are constantly failing refreshes over the weekend and before and after work. Basically I barely see fails during work hours. Each report has about 15,647KB to a small report having 266KB but they are all failing constantly. I am connected to the SQL server where I am retieving this data. I have refreshes set every 2 hours starting from 6am to 6pm. I need to fix this problem your assistance is appreciated. Also want to let you know that I have checked the gateway and my connections are good. 

 

  • Anonymous's avatar
    Anonymous
    1 year ago

    Hi, Anonymous 

    Merry Christmas to you. Since we haven't heard back from you yet, I'd like to confirm if you've successfully resolved this issue or if you need further help?

    If you still have any questions or need more support, please feel free to let us know. We are more than happy to continue to help you.
    Thank you for your patience and look forward to hearing from you.

     

    Best Regards

    Jianpeng Li

6 Replies

  • what's the actual refresh error? Your screenshot is cut off.

  • Anonymous's avatar
    Anonymous
    Not applicable

    Thank you lbendlin 

    Hi, Anonymous 

    Because scheduled refresh is also automatically disabled after four consecutive errors or two months of inactivity for the corresponding report for this dataset, your dataset refresh is disabled. As mentioned in the official documentation:

    Configure scheduled refresh - Power BI | Microsoft Learn

    You mentioned that you are working fine Monday through Friday. Saturday and Sunday failed. Your refresh failure should review the error message below your screenshot and configure it as instructed. It is not limited to the following questions:
    1. The gateway goes offline on weekends, resulting in the inability to reach the data source during refresh. For example: A local data source is used, and then the computer shuts down over the weekend
    2. Your credentials are invalid, resulting in an access error.
    3. Your inquiry question.

    You can view the full error message in the refresh history:

    Refresh summaries for Power BI - Power BI | Microsoft Learn

    You can check out these posts below for similar problems to try their solutions.

    Solved: Scheduled refresh has been disabled. - Microsoft Fabric Community

    Solved: Due to consecutive errors, scheduled refresh has b... - Microsoft Fabric Community

    Solved: Scheduled refresh has been disabled - Microsoft Fabric Community

     

     

     

    Best Regards

    Jianpeng Li

    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

    Hi, Anonymous 

    I wish you all the best. Previously we have provided a solution to help you solve the problem. Since we haven't heard back from you yet, I'd like to confirm if you've successfully resolved this issue or if you need further help?
    If you still have any questions or need more support, please feel free to let us know. We are more than happy to continue to help you.
    Thank you for your patience and look forward to hearing from you.

     

    Best Regards

    Jianpeng Li

  • Anonymous's avatar
    Anonymous
    Not applicable

    Hi, Anonymous 

    I wish you all the best. Previously we have provided a solution to help you solve the problem. Since we haven't heard back from you yet, I'd like to confirm if you've successfully resolved this issue or if you need further help?
    If yes, you are welcome to share your workaround and mark it as a solution so that other users can benefit as well. If you find a reply particularly helpful to you, you can also mark it as a solution.
    If you still have any questions or need more support, please feel free to let us know. We are more than happy to continue to help you.
    Thank you for your patience and look forward to hearing from you.

     

     

    Best Regards

    Jianpeng Li

  • Anonymous's avatar
    Anonymous
    Not applicable

    Hi, Anonymous 

    Merry Christmas to you. Since we haven't heard back from you yet, I'd like to confirm if you've successfully resolved this issue or if you need further help?

    If you still have any questions or need more support, please feel free to let us know. We are more than happy to continue to help you.
    Thank you for your patience and look forward to hearing from you.

     

    Best Regards

    Jianpeng Li

    • Anonymous's avatar
      Anonymous
      Not applicable

      Hi, Yes I figured out I was signed into the wrong gateway.