Forum Discussion
Connecting to Google Drive Folder
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.
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,
Super UserThere 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.