Power BI dataset refresh fails with gateway connection error

asked 3 days ago9 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.

No Answers

Sign in and verify your email to post an answer.