Forum Discussion
Solved
SharePoint CSV - Scheduled Refresh Failing
I've got several Desktop created reports that I've published and setup scheduled refreshes on the datasets. They contain direct SQL queries as well as a query to a CSV file stored on SharePoint Onlin...
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).