Forum Discussion
Onedrive data refresh failure
Sorry but that doesn't make sense. My understanding is a gateway is necessary in order to process any queries to on-premise sql databases. What you are describing suggests that a gateway isn't necessary for running queries to SQL on premise.
v-qiuyu-msft I'm with burnie21 here. Everything I'm testing around the "connect" scenerio to Excel in OneDrive for Business is either not working or results in an error with the EG. The documentation lays out that the refresh scenerio in this case should require a gateway to use the connection to the SQL server via the Excel file. And that the data will be updated in the Excel file.
Your test scenerio is flawed as you are manually refreshing from the Excel file. The test should be initiated from the Service and the data should update in the excel file via "Refresh Now".
The scenerio works with my personal gateway, but when I switch over to the EG, I had one successful execution of the "Refresh Now" process, but it didn't update the data in the Excel file. When I switch back to the PG, it works again. (albeit I have to hit F5 to refresh the connection in Power BI to see the updated results reflected.)