Due to concerns with the 'permanence' of OneDrive file structures (files become unavailable if the creator leaves the organization), I have been asked to change to from using OneDrive to Office 365 files.
Thus far I have been successful when changing an "Excel" data source, but not when trying to change from a previously created "Folder" data source, getting the following error: "The folder path must be a valid absolute file path".
Is what I'm attempting possible? If so, what am I missing?
I assume you are talking about using a Sharepoint folder?
There are some instructions here on that topic: