Forum Discussion
Onedrive data refresh failure
Hi, I am getting a data refresh error on a file hosted in OneDrive, using data managment gateway (Enterprise). The file refreshes fine using excel in the desktop, but when I try to refresh in Pow...
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.