Notifications
Clear all
Power Query
3
Posts
2
Users
0
Reactions
98
Views
Topic starter
Hi, I have excel files within a folder in Google Drive that I want to load into Power Query. I know how to load a local folder into Power Query but am finding it difficult to work out how to load a folder from Google drive into Power Query. The documents in the folder are all Excel documents not Google Sheets. Can anyone help me out please?
Posted : 20/04/2019 10:44 pm
Hi Karen,
I'm not aware of any way to connect to a cloud folder.
The solutions I've found recommend you sync the Google Drive folder to a folder on your local PC or network drive and connect to them via the From File > From Folder with reference to your local or network drive containing the files.
Mynda
Posted : 21/04/2019 9:34 pm
Topic starter
Thank you Mynda. I thought that may be the only way to do it but just wanted to make sure.
Karen
Posted : 22/04/2019 4:42 pm
