Gateway Scheduled refreshing Problem

Hi mellolu, 

What error messages are you getting when the refresh fail? This will help us determine the root cause. 

Here's some steps to troubleshoot: 

1) Get the exact error: In the dataset’s settings, open Refresh history and copy the latest failure text. It points to the real cause and helps avoid guessing. Microsoft doc
2) Rebind to the gateway: In Settings > Gateway connection, pick the correct gateway and map every data source. Server, database, and file paths must match exactly what your queries use. If Desktop used an IP or a different server alias, create the same on the gateway data source or update the queries. Microsoft doc
3) Re-enter credentials: In Settings > Data source credentials, sign in again for each source. This is the most common fix after password or token changes. Microsoft doc
4) Update the gateway: Install the latest gateway on the server and restart the Windows service. Old builds can break after security changes. Microsoft doc
5) Use UNC paths for files: If your model uses files or folders, change mapped drives like X:\ to a UNC path like \\server\share\folder in both Desktop and the gateway data source. Radacad guide
6) Fix privacy levels: If you combine sources, set all privacy levels consistently (usually Organizational) in Desktop and in the Service. This resolves the “Information is needed in order to combine data” failures. Microsoft doc
7) Network and TLS: Ensure outbound ports are open (443, 5671–5672, 9350–9354) and the box uses modern TLS. Proxies can also block Service Bus traffic. Microsoft doc
😎 Region alignment: The gateway’s region should match your tenant/environment. If it doesn’t, reinstall and pick the right region. Microsoft doc

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