Forum Discussion
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...
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.
Check the 'Data Source settings' for your project (Under the 'Edit Queries' button). Does your source path math the One Drive you are expecting? Would it be possible that you have linked to a different one drive location that happens to also contain the same file? I'm wondering if you are making changes in the wrong place and thus you are still seeing the older information.