Forum Discussion
Onedrive data refresh failure
Hi burnie21,
Based on my test, refresh data from OneDrive file doens't need gateway. When the SQL Server table is updating with new records, we need to refresh the Excel via Data -> Refresh All button, then save the change. Then when we click Refresh Now in Power BI Service, the PowerPivot table data will update correspondingly. Please follow the steps like us to check if the issue persists.
Best Regards,
Qiuyun Yu
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.)