Showing results for 
Search instead for 
Did you mean: 

Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.

New Member

Data refresh error in power bi service


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.



Please help.

Thanks in Advace

Pushpendra Singh


Regular 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

PBI November 2023 Update Carousel

Power BI Monthly Update - November 2023

Check out the November 2023 Power BI update to learn about new features.

Community News

Fabric Community News unified experience

Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.

Power BI Fabric Summit Carousel

The largest Power BI and Fabric virtual conference

130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.

Top Solution Authors
Top Kudoed Authors