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 decided to delete the dataset and rebuild the report from scratch,
However when I connect to my OneDrive file it still imports the old Table1 name with old data headings and values.
Why? And how do I resolve it to connect to the latest data.
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.
10 Replies
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.