Power BI Gateway Error: DM_GWPipeline_Gateway_DataSourceAccessError Occurring Sporadically

Hi ollie_mills ,
Below are the steps you can follow to troubleshoot your issue:

1. Update the Gateway
   Ensure you are using the latest version of the on-premises data gateway.
   Microsoft regularly releases bug fixes and stability improvements.

2. Check Azure VM Performance
   Monitor CPU, RAM, and disk I/O during refresh windows.
   High CPU spikes or memory pressure can cause the gateway to time out or drop requests.
   Consider scaling the VM size or increasing the performance tier if it’s under strain.

3. Use a Dedicated Gateway VM
   If the VM is also running other workloads (e.g., SQL Server, SSIS, IIS), they might interfere.
   Using a dedicated VM solely for the Power BI Gateway can reduce contention and increase stability.

4. Enable Gateway Logs at Verbose Level
   Although the logs may not currently show this specific error, enabling detailed logging might reveal more insights.
   Use the Microsoft.PowerBI.DataMovement.Pipeline.GatewayDiagnostics and EnterpriseGatewayConfigurator.exe tool to configure verbose logging.

Providing the links to check the details of latest gateway,vm monitoring,troubleshooting guide lines

Download latest gateway version : https://www.microsoft.com/en-us/power-platform/products/power-bi/gateway

Monitor Azure VM with Azure Monitor : https://learn.microsoft.com/en-us/azure/azure-monitor/fundamentals/overview

Power BI Gateway Troubleshooting Docs : https://learn.microsoft.com/en-us/data-integration/gateway/service-gateway-tshoot

Regards,

Chaithanya.