Importing Data from Google drive to Excel Power Query

[ankitsingh2063]

Hello community,

I am trying to write a Power Query to 'Get Data' from a Google Drive folder that contains multiple google sheets in the same format and same spreadsheet name across all files.

I am not sure where to start and how to start.

[#2]

I'm with the same question

[#3]

@mychellVALEC 

If you're looking to combine several Google Sheets documents from Google Drive, that's currently only possible  via the PowerBI Google Sheets connector