Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Microsoft is giving away 50,000 FREE Microsoft Certification exam vouchers. Get Fabric certified for FREE! Learn more

Reply
Pushpendra_41
New Member

Data refresh error in power bi service

Hi, 

I have been using power bi for some time but never used gateways to refresh the data, So installed local gateways and conneced with SQL Server and created schedure refresh, but when I tried to refresh the data it is showing an error like this :

Last refresh failed: 9/21/2023, 10:21:11 AM.

It is showing an error :

"

Last refresh failed: 9/21/2023, 10:21:11 AM
There was an error when processing the data in the dataset.

DM_GWPipeline_Gateway_TimeoutError:DM_GWPipeline_Gateway_TimeoutError","parameters":

 

Please help.

Thanks in Advace

Pushpendra Singh

 

1 REPLY 1
oschroeder
Frequent Visitor

That error is a symptom that connectivity doesn't exist between the gateway and the SQL Server that you are attempting to access.

I would confirm that you have access to the SQL Server using SSMS with the same credentials you plan to use with the Gateway from the machine where you have the gateway installed. 

You need to clarify if this is a personal gateway (downloaded) to your machine (typically not recommended unless the machine is a workstation wired into your network and on 24/7) or a VM in which you install the gateway. 

Our gateway is the later case, where I have to have Infrastructure open up the ports and access on that VM to the SQL Server databases that the Gateway will access and then configure the gateway there on that VM.  I have not used personal gateways.

Helpful resources

Announcements
PBIApril_Carousel

Power BI Monthly Update - April 2025

Check out the April 2025 Power BI update to learn about new features.

Notebook Gallery Carousel1

NEW! Community Notebooks Gallery

Explore and share Fabric Notebooks to boost Power BI insights in the new community notebooks gallery.

April2025 Carousel

Fabric Community Update - April 2025

Find out what's new and trending in the Fabric community.

Top Solution Authors