Forum Discussion
SharePoint CSV - Scheduled Refresh Failing
They should behave the same as scheduled... does anything in this thread help? It's the same error code: https://community.fabric.microsoft.com/t5/Desktop/Expression-Error-There-weren-t-enough-elements-in-the/m-p/42288
Does the service account have access to the the site that the file is in? It needs read access at the site level, not just to the file. It looks like a permission issue to me (it can't find the thing it's looking for because it doesn't have access to it).
I've confirmed it is a contributor on the site with ready/write access. As I mentioned, when I click the refresh icon in my datasets it works fine, it's only the scheduled refresh that fails. There are no other actions taking place at that time with other reports either.
There should be no difference between the scheduled refresh and the web service refresh. Desktop could be different if it's using different credentials there. You do need to enter the credentials in the datasource settings in the web app after publishing if you haven't done that yet (it's on the scheduling page).
Yup, I've got the credentials entered, I've tried using my own as well as a service account with full access to the SharePoint site and still having the same issue. When I go into PBI Service I can manually refresh the dataset but the scheduled refreshes fail. I've also realigned all the affected reports to refresh at separate times so they don't step on each other.
