Forum Discussion
Power BI Service Auto-Refresh Failing
That's a weird error that I haven't seen before. Scheduled refresh does work with OneDrive sources similar to SharePoint, since it is SharePoint, but you need to enter credentials in the refresh settings in Power BI. I have a tutorial on how to set up the refresh here - this one is for SharePoint, but the concept is the same: https://youtu.be/ba1Akv63GDQ
Make sure that the path you're using in the query for the file source is the cloud path, not the synced local path, assuming you want to avoid using the gateway.
Keep in mind that if you use OneDrive that your source is tied to your account, so if you leave your org it gets deleted. If you need it to keep running long-term, you might consider moving it to a shared site.
Thanks for the reply.
I'm fairly sure it's setup correctly because I got it to work initially. This problem occurred at some point after publishing a change to the report via the desktop app. Could it be a problem related to power query or dax?
When I click the refresh button it just spins for a while and then shows a little triangle with the warning message below...
Data source error: One or more errors occurred.;One or more errors occurred.
The specified package is invalid. The main part is missing.. The exception was raised by the IDbCommand interface. Table: ECL_Facts.
Cluster URI: WABI-UK-SOUTH-C-PRIMARY-redirect.analysis.windows.net
Activity ID: 2e9be358-1db1-426e-8323-55e4e84f9eeb
Request ID: 9ce7f094-cf3f-1f4e-cd42-1dda26acf646
Time: 2024-10-29 17:27:17Z
There's a thread on this particular error here, is there any chance that the filetype of the source files changed? https://community.fabric.microsoft.com/t5/Service/Data-Refresh-Error-The-specified-package-is-invalid-The-main/m-p/495214
Thanks Christine, I've been through this thread and couldn't see a solution... I've checked the data files and they are definitely in standard format.