Showing results for 
Search instead for 
Did you mean: 
Post Patron
Post Patron

Connecting to Google Drive FOLDER

Hello - 

I have a client that uses Google Drive to store their files.  I am trying to connect Power BI to a FOLDER on Google Drive, but am not having any luck finding a solution for this.  I have looked at some of the threads on here, but there do not appear to be any solutions.


Does anyone know if there is a way to connect to an entire folder from Google Drive, similar to what you would do with a local folder so you can pull all the files in at once, and when a new file is added you only have to refresh the dataset?


Any insights, help or documentation on this would be appreciated.  I find it hard to believe Microsoft does not have a Google Drive connector.





Community Support
Community Support

Hi @ryan_b_fiting,

Nope, current folder connector only works with the local path.
For your scenario, you can consider using web connector(work with 'rest API'/'web service'), other connector drivers (e.g odbc driver) or create a custom connector to achieve your requirement.

Starting to Develop Custom Connectors 


Xiaoxin Sheng


Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.
Community Champion
Community Champion

Hi @ryan_b_fiting ,


I used Google Scripts and Triggers to do it.


1-> Share a folder;

2 -> Create a Google Spreadsheet to store all shared urls;

3 -> Create a script to get all shared url on the sheet;

4 -> Create a trigger to update the sheets (I have scheduled once a day, but you have many options). You can find the Trigger Editor on "Edit -> Current Project's Trigger". Just select the script function you saved and the recurrency;

5 -> Connect the Spreadsheet (item 2) to Power BI;


This is the script I used:


function onLoad() {
var ss=SpreadsheetApp.getActiveSpreadsheet();
var s=ss.getActiveSheet();
var c=s.getActiveCell();
var fldr=DriveApp.getFolderById("USE_THE_SHARED_FOLDER_URL");
var files=fldr.getFiles();
var data=[],f,str;
var ss = SpreadsheetApp.getActiveSheet();
ss.appendRow(["Name", "Date", "Id"]);
while (files.hasNext()) {;
data = [



I hope this helps you,




Did I answer your question? Mark my post as a solution!

Proud to be a Super User!

Helpful resources

PBI Sept Update Carousel

Power BI September 2023 Update

Take a look at the September 2023 Power BI update to learn more.

Learn Live

Learn Live: Event Series

Join Microsoft Reactor and learn from developers.

Dashboard in a day with date

Exclusive opportunity for Women!

Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!

MPPC 2023 PBI Carousel

Power Platform Conference-Power BI and Fabric Sessions

Join us Oct 1 - 6 in Las Vegas for the Microsoft Power Platform Conference.

Top Solution Authors