Forum Discussion
Filename.xlsm OneDrive Refresh Disabled
I have a XLSX file stored in OneDrive for business and the scheduled refresh from it has been working great for months up until last Friday the 13th. That was the last time the refresh occurred. I try runing the scheduled hourly OneDrive refresh back on for the data source, then I soon get an email telling me it's been disabled.
I've gone through all the help topics and haven't discovered yet why it won't refresh.
----ERROR----
FILENAME.xlsm has been disabled. You can learn about common reasons refresh fails in our help topics or reach out to our Community for help. As always, you can also contact support.
If you contact support for this issue, please provide them with the following information:
Activity Id: 22f74e02-c524-46dd-bf1f-812fe569950e
Request Id: 158636b1-4af4-4a42-abe8-5f7a9da97dba
Cluster Name: WABI-US-NORTH-CENTRAL-redirect.analysis.windows.net
Refresh Start Time: 04/18/2018 15:58:43Z
Refresh End Time: 04/18/2018 15:58:51Z
7 Replies
I'm not sure about the "publish" you mention, although our normal process is to update the file "in place" one OneDrive and rely on PowerBI to see the changes to the file (usually very quickly). I am not sure why it lost the relationship to the file on Friday (or indeed if that's even what occurred, I just know it says scheduled refresh is disabled).
I wanted to try setting it up again using "Get Data" but I don't want to rebuild all the reports and dashboards that consume data from that file, so I'm hoping it can be re-linked (sort of how you described).
It took me 6 months to convince Microsoft that the link to Onedrive had been compromised. After that, it was just a couple of hours before they reset it on the backend. I had 25 reports pulled from that single dataset so, similar to you, I was not in a rebuilding mood. Microsoft can reset the connection for you. You will have to file a support ticket for this and go through the process. If you really push the issue, it could be a simple one day solve. You may have to be really firm with them, though, because their default answer will be that they cannot do this. Don't believe them. If need be, I can email you my case number for them to pull the process. If it comes to that, let me know.
Microsoft can be very stubborn.
