- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Data refreshes have suddenly stopped working
Hi,
We have several Power BI reports available for users to run through the site. We have the on-premises gateway installed, and a SQL server VM hosting the databases that the Power BI reports collect their data from during refreshes. This has all been working fine over the last few years.
All of a sudden, starting last night, our scheduled refreshes failed. We are consistently getting one of the two following messages:
"DM_GWPipeline_Gateway_SpooledOperationMissing"
"The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections."
Nothing should have changed with the Gateway, with the SQL Server data, or with any firewalls or Windows updates. It looks like I can refresh this data locally through Power BI desktop for these reports without an issue and connect to the databases via SQL Server Management Studio, but when I publish the report online through the Power BI site, I still see one of the two above errors beside the dataset Refreshed date. Oddly enough, one of our reports, though it failed with the "Server was not found or was not accessible" error last night, did rerun successfully through the site. The others all continue to fail.
I'm having no difficulties accessing the data through Power BI Desktop. The issue appears to only be affecting the Power BI site and data gateway.
UPDATE: I'm intermittently seeing that Gateway connections in the site are showing an error "Gateway or datasources not reachable". When I go to manage connections and gateways on the site, I see that the gateway itself is online, but most of the connections are offline with an error of "DataSourceUnreachable", "SqlException encountered while accessing the target data source." After restarting the gateway service, they seem fine again, but after failed refreshes, they seem to revert back to an offline state.
How do I begin troubleshooting these strange errors?
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Found the issue. The sys admins had cloned the server that included both the on-premise data gateway and SQL databases as part of some other testing they were doing. After they powered off the clone, I was able to refresh data through the site again.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Found the issue. The sys admins had cloned the server that included both the on-premise data gateway and SQL databases as part of some other testing they were doing. After they powered off the clone, I was able to refresh data through the site again.

Helpful resources
Join our Fabric User Panel
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Power BI Monthly Update - June 2025
Check out the June 2025 Power BI update to learn about new features.

User | Count |
---|---|
4 | |
3 | |
1 | |
1 | |
1 |
User | Count |
---|---|
7 | |
5 | |
4 | |
3 | |
3 |