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

[Brjt1]

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 · Accepted solution]

Hi, @Brjt1 

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

[Brjt1]

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

[Anonymous]

Hi, @Brjt1 

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]

Hi, @Brjt1 

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]

Thank you lbendlin 

Hi, @Brjt1 

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.

[lbendlin]

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