I am facing the same issue
1. used web connector to connect to excel on onedrive for business
2. suto schedule is not working
but when i try to use a gateway (just like it is suggested) it still gives me an error. Under the gateway there is no "oauth" option and using the basic, anonomus, and windows still gives me an error.
Can I can now refresh my report which is conneted to excel on ODFB?
I managed to get Google Sheets to work instead for another document (more like, it hasn't given me an error yet..) based on some other searching on the internet so not entirely my own discovery:
The gateway is also giving an error when i try to add the Excel ODFB link as data source. Can you please provide guidance on how the gateway refersh will work for web services. Additionally there is no Oauth option in the gateway.
The error you're running into is due to a different issue. The good news is that the fix should be in PROD soon, stay tuned, I'll post a comment here once it's online.