Power BI Online with Excel on OneDrive for Business Unable to Perform OneDrive Refresh

[elarson]

This has been working for months perfectly.  I had to change my password for work and fear this caused it.  I did also delete the file from the OneDrive for Business but I replaced it with an earlier copy that was working the day prior.  Need help urgently!  I have tried a scheduled update just as a test but that fails with a reason that a column does not exist in a table in the rowset.  However, i have updated those in the file so that it does exist and yet still get the same error.  Any thoughts or ideas?  Thanks!!!

"We are unable to locate the file on OneDrive for Business. Please check that the file exists in this location"

[Anonymous]

Same issue here

[v-qiuyu-msft]

Hi @elarson,

According to your description, you previously connected to OneDrive for Business Excel file in Power BI Service. But you deleted the file from the OneDrive, and replaced with another Excel file. When refreshed, the error threw out, right?

From the error message, it seems that the link between Power BI service and OneDrive for Business file is broken, so the Power BI Service can't find the corresponding file stored in OneDrive. In your scenario, please re-import the Excel to Power BI Service, then please click the Refresh Now to check if the connection is fine. Then enable the OneDrive Refresh to see if the issue persists.

If you have any question, please feel free to ask.

Best Regards,
Qiuyun Yu

[sunrit]

hi,

i have had the same issue and the error message. when i connect again the dataset, it creates a second dataset. so the existing reports cannot be linked to the updated data set. can you help in this matter else the only choice appears to recreate the reports which is a huge huge task.... thanks

[sunrit]

I have not deleted the old file, but just appended the data.