Forum Discussion

andrewsimmans's avatar
andrewsimmans
Icon for Helper I rankHelper I
11 years ago

Excel PowerPivot in OneDrive will not refresh - but it works for same Excel saved locally

Weird error here - I have a an Excel 2013 Powerpivot spreadsheet reading from an on-premise SQL server.   If I save this locally and then load it directly up into Power BI then the refresh via the ...
Youssef's avatar
Youssef
Icon for Microsoft Employee rankMicrosoft Employee
11 years ago

Hi, thanks for reporting the problem. There is a known problem the team is working on where the OneDrive refresh (that happens on hourly basis) overwrites the scheduled refresh through your personal gateway, so you end up with the stale data that is in the workbook rather than the data that was refreshed directly from the data source. Does this look like the problem you are encountering? 

 

If not, and the problem is still happening, can you share the activity ID that you get when you see this error and we'll investigate the issue.