On premise gateway

Hi Richard76 

The error is indicating that your source system timed out and stopped sending data.

 

I would suggest contacting the data source owner and checking how long the timeout is set to, as it is currently too short. Or also check to see if the data is being imported as quickly as possible and might need a query optimization.

Hi  Richard76 ,

1. Whether your gateway is the latest version, if not, you can update it.

https://docs.microsoft.com/en-us/data-integration/gateway/service-gateway-update

2. Is the gateway server condition bad, has the memory reached the limit, Competition for resources? With MS only allowing refreshes to be every 30 min, there is a rush for resources from other reports.

3. You can extend the timeout period by following the steps in the link below.

Set a max run time / timeout for Power Query

Setting Timeout Value in Powerquery

 

This is the related document, you can view this content:

https://community.powerbi.com/t5/Issues/Intermittent-refresh-failures-Data-source-timed-out/idi-p/657701

https://community.powerbi.com/t5/Issues/Scheduled-Refresh-Fail-Before-the-data-import-for-xxxxxxx/idi-p/666201

https://jd-bots.com/2021/03/21/fixed-before-the-data-import-for-finished-its-data-source-timed-out/

https://community.powerbi.com/t5/Issues/Before-the-data-import-for-Data-Source-Name-finished-its-data/idi-p/604041/page/2

 

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.