Forum Discussion
Helper IIReport refresh failure with OneDrive connection
Hi.
I have a report which uses OneDrive files as a part of its data source. Automatic and manual refresh of this report fails frequently (but not always) with this error:
All of queries regarding OneDrive sources are in this format:
Any ideas why connecting to a Microsoft-hosted data source from a Microsoft-hosted service should fail 60% of times?! I have already enabled "Allow your Microsoft 365 services to process or store Power BI data which may be outside of your Power BI tenant's geographic area." option in admin portal (in case it matters).
4 Replies
v-xiaotangCommunity Support
Thanks for reaching out to us.
You mean, this file sometimes refreshes successfully and sometimes fails to refresh? Are there any regularities in the scenarios in which they occur?
Best Regards,
Community Support Team _Tang
If this post helps, please consider Accept it as the solution to help the other members find it more quickly.
- SajjadMousavi
Hi.
Yes, that's excatly what you said. And unfortunately, there is absolutely no regularities in this failures. The same files (two reports, different aspects of data), the same refresh schedule for both reports, the same OneDrive files for both, but sometimes both refresh successfuly, sometimes one of them fails, sometimes both fail together!!! And there is no pattern for schedule failures. Sometimes 10:00AM fails, sometimes 3:00PM fails and sometimes 10:00PM fails.
- v-xiaotang
Thanks for your reply.
If you refresh it in Power BI Desktop, will it always refresh successfully
Best Regards,
Community Support Team _Tang
If this post helps, please consider Accept it as the solution to help the other members find it more quickly.
