Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Connecting to OneDrive Excel Online

I have a report connected to an Excel Sheet in OneDrive.   The data has been updated but the updates are not flowing into the dashboard. I've tried manual refreshes over a 48 hour period.   I dec...
  • Anonymous's avatar
    Anonymous
    7 years ago

    OK, I think I have solved it! My excel file has a power pivot which wasn't refreshed. So my live data was in an Excel table called 'Tracker' whereas the Power Pivot was calling on data from an old table called 'Table1'. Power BI was uploading Table1. I deleted Table1 from the Data Model and that fixed it.