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

Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now

Reply
Anonymous
Not applicable

Unable to connect: The gateway is either offline or couldn't be reached

I have a report built with a connection to a server with SQL Server and to some files that I have both locally and in corporate Sharepoint (currently they are configured as Web Data Type and OAuth2 authentication method). This report is scheduled to be updated 5 times a day.

The gateway is installed on my computer and it does not stay on. Because of this, when I turn off my computer the report does not update, the error says "the gateway is either offline or couldn't be reached".

I was checking and I was able to identify that when the computer is offline, Power BI still connects to the server but fails to connect to the Sharepoint files. I would like to know if there is any way that the Sharepoint files do not have to go through the Gateway but it goes directly to Sharepoint to update this connection.

Thanks for your help, best regards.

 

1 ACCEPTED SOLUTION
GilbertQ
Super User
Super User

Hi @Anonymous 

 

The only way that this could work is if your sources are all in the cloud.

 

If one source is on-premise in your PBIX you will have to always have the gateway on to refresh the dataset.





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!







Power BI Blog

View solution in original post

1 REPLY 1
GilbertQ
Super User
Super User

Hi @Anonymous 

 

The only way that this could work is if your sources are all in the cloud.

 

If one source is on-premise in your PBIX you will have to always have the gateway on to refresh the dataset.





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!







Power BI Blog

Helpful resources

Announcements
OCT PBI Update Carousel

Power BI Monthly Update - October 2024

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

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

October NL Carousel

Fabric Community Update - October 2024

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

Top Solution Authors
Top Kudoed Authors