Desktop Refresh works but scheduled refresh has error

Hi, Anonymous 

It looks like the scheduled refresh failed due to a data source error, specifically an issue with the TCP Provider. The error message suggests that there was a timeout period that expired while the server was receiving results from the data source.

Regarding your questions:

1. The "provider: TCP Provider, error: 0" message refers to a network error that occurred while the data was being transferred between the server and the data source. The "semaphore timeout period has expired" message suggests that the server was waiting for a response from the data source, but did not receive it within a specified time period. This could be due to a variety of factors, such as network congestion or a slow data source.

2. The error message specifically mentions the table "myTableName", which suggests that the issue may be related to that particular table. It's possible that there is an issue with the data in that table, or with the way that it is being accessed by the server.

Troubleshoot refresh scenarios - Power BI | Microsoft Learn

Best Regards,

Community Support Team _Charlotte

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