Connecting to Google Drive Folder

[M-Beans]

Hi,

  I've researched this in the forum but most posts are older and don't seem to have a solution for my issue.  

I have the following Version: 2.126.927.0 64-bit (February 2024) of Power BI desktop.  

Is there a way to connect to a google drive folder ?  I'm trying to combine multiple years of uptime data that are in google sheet files by year. 

Regards  

[Sergii24]

Hi @M-Beans, have you tried "Google Sheets" connector?

[M-Beans]

Hi @Sergii24 ,

  Yes I'm able to connect to a single Googlesheet, but I'm trying to connect to a Google Drive Folder that has multiple googlesheets that I want to combine the year over year data.

Regards,

[Sergii24 · Accepted solution]

There is no native connection to Google Drive folder.

You can access the sheets separately and then append them one under another in PowerQuery (in case you have limited number of files). In case you expect to often add new files you might want to use PowerAutomate to automatically copy those files to SharePoint and then connect to SharePoint folder from PowerBI or use some custom paid connector to connect directly to Google Drive folder.