Forum Discussion
One drive connected excel is no longer refreshing.
- 1 year ago
Hi elliottlawlor ,
Normally, this is an error indicating that this is not "finding" the file. Please confirm that EVERYTHING is exactly the same as it was before. And, confirm that the data source in the gateway is reaching it. The file name or path might have changed slightly
OR, the permissions have changed. I would expect the error to be a bit different if it was permissions though but it is possible.
Hi elliottlawlor ,
Normally, this is an error indicating that this is not "finding" the file. Please confirm that EVERYTHING is exactly the same as it was before. And, confirm that the data source in the gateway is reaching it. The file name or path might have changed slightly
OR, the permissions have changed. I would expect the error to be a bit different if it was permissions though but it is possible.
The file name and location are exactly the same.
I took a copy of the excel and moved it to another one drive location and then connected it and everything worked fine.
It did show different options in the settings compared to teh existing one that is not refreshing. I conncted this excel back in 2020 so maybe some things have changed.
I have also been into managed connection and gateways and can see the file in there with a status of refreshing. However there is another sharte point connection which is saying it is failed:
Details: The credentials provided for the Web source are invalid. (Source at https://ejpropertycouk-my.sharepoint.com/personal/elliott_ejpr_co_uk.) Please have this information handy if you choose to create a support ticket. Session Id: 57ffaeb2-03d1-42ba-b482-2d7496a3ffdf RequestId: a39be2a0-7b78-4b21-b653-6793f34b6575 Cluster URI: https://api.powerbi.com Status code: 400 Time: Wed Jun 11 2025 11:16:34 GMT+0100 (British Summer Time)