Forum Discussion
Connecting to Google Drive Folder
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
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.
3 Replies
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.
