Can anyone suggest to me how we can access Onedrive data directly in the Metabase?
CData to a product that allows you to connect to OneDrive as a linked server. Not used it, but looks interesting.
Alternatively, Zapier to pull data around. Again, not used.
Personally, assuming it's an Excel file you want to use, I'd setup some sort of data extract using SSIS, Talend or similar.
In summary, you need your file to be visible as a database to Metabase.