Issue with the refresh in the service

Hi kc_302, 
There's another thread about this same issue: Schedule refresh failed. - Microsoft Fabric Community

On that thread a CST posted this: 

This error happens because Power BI Service runs your refresh differently than Power BI Desktop. On Desktop, you’re connecting directly with your machine’s drivers, but in the Service, the refresh depends on either the cloud connector or the On-premises data gateway. This error message usually points to the Service struggling to read large chunks of data, either because of a gateway misconfiguration, invalid credentials or a query that pulls back too much data and times out when run in the Service. That’s why it works locally but fails when scheduled online.

To fix it, first make sure your dataset is mapped to the correct gateway in the Power BI Service and that credentials are valid under Dataset settings -> Data source credentials. If the gateway is fine, then look at query performance, apply filters in Power Query, enable query folding or reduce the size of data pulled back so the Service isn’t timing out. If you’re connecting to SQL, also check the command timeout in Power Query and increase it if needed.

Configure scheduled refresh - Power BI | Microsoft Learn

Install an on-premises data gateway | Microsoft Learn

If you found this helpful, consider giving some Kudos. If I answered your question or solved your problem, please mark this as the solution