Power BI dataset refresh fails with gateway connection error
asked 2 months ago76 viewsen
0
My Power BI dataset connects to an on-premises SQL Server database. The dataset refreshes successfully from Power BI Desktop, but scheduled refreshes fail in Power BI Service.
Refresh failed:
Unable to connect to the data source.
Gateway connection failed.
Data source: SQLSERVER01\PROD
Error Code: DM_GWPipeline_Gateway_MashupDataAccessError
Environment:Power BI ServiceWindows Server 2022
AI diagnosis
AI-generated. Not an answer — the community below confirms or corrects it. Always verify before relying on it.
asked 2 months ago
Jean Pierre 5.1k
No Answers
Sign in and verify your email to post an answer.