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

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

Not applicable

Report can't find previously working data source (insists on gateway even though cloud source)

I connect to my work network from home via "cognitas crosslink" VPN. My directquery SQL server data source for a particular report can not be reached over the VPN from power bi desktop. (I'm looking in to fixing that.... But that's not my issue I'm posting about)

The power bi web server however CAN see the data source. So, I can live with this, by only editing the report when I am on the physical work LAN, and publishing from the work LAN. Again, the report can be viewed in power bi online both at home and at work (and, for example, via mobile phone... So normally no problem with the data source via the report server normally)

Regrettably, yesterday I made a change to the report while at home, where the data source couldn't be reached, and then published the report. My thinking was that the report server has its own route to the data source so everything would be ok: however the report is now broken with red warning at top of page "There is no gateway to access the data source [XYZ]"

Other reports with same data source work fine. A brand new report with same data source works fine (I.e. built today trying to diagnose problem). I tried completely removing and re-adding the data source and removing all credentials but get the same error. It is as if it has cached a route based on my home network via crosslink, interpreted that as needing a gateway to be added, and is now no longer "trying fresh" to reach the data source? The broken state is saved in the report somehow?

Possible contributing factor: the reason for the change I wanted to publish, was I had accidentally imported a small excel table and forgot to turn off refreshing. So the web server was failing to refresh based on that fact. But now it's failing to refresh the main data source (only other source, as described above)

Helpful resources

Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

February 2024 Update Carousel

Power BI Monthly Update - February 2024

Check out the February 2024 Power BI update to learn about new features.

Fabric Career Hub

Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

Fabric Partner Community

Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.