Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Solved! Go to Solution.
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.
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.