Forum Discussion
Issue with excel data refresh when stored on OneDrive
Hi kcraven-grew ,
Power BI performs refresh based on an item ID in OneDrive, so be thoughtful when considering updates versus replacement. When you set a OneDrive file as the data source, Power BI references the item ID of the file when it performs the refresh. Consider the following scenario: you have a master file A and a production copy of that file B, and you configure OneDrive refresh for file B. If you then copy file A over file B, the copy operation deletes the old file B and creates a new file B with a different item ID, which breaks OneDrive refresh. To avoid that situation, you can instead upload and replace file B, which keeps its same item ID.
About more details you can refer to: Data refresh in Power BI - Power BI | Microsoft Docs
If there are still problems with the refresh, you can also try another account to test whether the refresh can be successful.
Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Has this always been an issue or is this something that only started recently? Does this error occur in the service environment or in Desktop? If in the service environment, have you checked your gateway settings/ status?
The source of the data needs to look something like this, open the advanced editor to see what it looks like in your situation:
let
Source = Excel.Workbook(Web.Contents("https://domain-my.sharepoint.com/personal/firstname_lastname_domain_extension/folder/file.xlsx"), null, true),
worksheet = Source{[Item="worksheet1",Kind="Sheet"]}[Data],
in
If that's the case, try editing the permissions for that data source (go to file -> options and settings -> data source settings -> edit permissions -> edit -> sign in as a different user -> sign in with the corresponding account.
That fixed a refresh issue for me some time ago.