Get Data from Multiple Folders in GoogleDrive - Possible?

chandelirious

Board Regular
Joined
Sep 9, 2004
Messages
84
Hi all,

I'm not at all familiar with PowerBI, so please bear with me!

I am sending a survey out to 120 establishments, and then need to collate the data when it returns. The survey is on an Excel spreadsheet. (They are expecting this, they are part of a network - it isn't just a mailshot!)

I was thinking of doing something like this:

Setting up a folder on GoogleDrive, called "Survey". Within that folder will be 120 folders. Within each folder will be one Excel spreadsheet, with the name of the establishment.

My aim is that once all the establishments have completed the survey, I can use the Get Data feature of PowerBI to merge all of this data into one table.

I have two questions:
1: Is this possible - particularly since I will need to set each GoogleDrive folder as accessible only to those with the link?

2: If the establishment then updates their survey, would that be reflected in the PowerBI table?

Originally, I had looked at doing this in Excel using GetData, but I think that PowerBI will be better able to handle the data.

When this has been done before (it's a quarterly task), establishments have been sent the survey by email, have returned it by email, and then someone has copied the data from each individual spreadsheet into one master spreadsheet. I hope to be able to eliminate that, and also would like to be able to keep the data up-to-date.

Thanks in advance!
 

Excel Facts

Return population for a City
If you have a list of cities in A2:A100, use Data, Geography. Then =A2.Population and copy down.
Thank you for this - I'm on a heavily locked down laptop, so I'll need to contact the IT department to see if they'll allow me to install Google Drive (hint: they'll say no!) But hopefully if I can convince them of the needs of the department, they'll let me - this looks like it will work.
 
Upvote 0

Forum statistics

Threads
1,225,537
Messages
6,185,513
Members
453,298
Latest member
Adam1258

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top