Power Query load files Google Drive

apoprio — Sat, 03 Dec 2022 03:01:22 GMT

Good evening everyone!
Well, I've seen that Microsoft has recently evolved a connector to load data from XLSX files that are inside Google Drive.
Example:

Source = GoogleSheets.Contents(....)
But our need is to read "all" XLSX files from a Google Drive folder.
Does anyone know how to effectively inform if there is a way to load "all" these files from a Google Drive folder as we do today with files that are Sharepoint or Onedrive ???

Example for Sharepoint:
Source = SharePoint.Files("https://site", [ApiVersion = 15]),

Example for Google Drive ???

Re: Power Query load files Google Drive

ppm1 — Sat, 03 Dec 2022 13:36:54 GMT

I suspect you'll need to use either the Google Drive REST API (e.g., get the actual files or the URL of all the files you can then use in the GoogleSheets.Contents function) or Google Drive File Stream.

Power Query from Google Drive - Excel University (excel-university.com)

Pat

topic Re: Power Query load files Google Drive in Power Query

Power Query load files Google Drive

Re: Power Query load files Google Drive