Automatic append file from Googledrive

[Anonymous]

Hi all, 

 I can do the auto-append file from my labtop folder.  But if I want to do it same with google drive folder.  is it possible to do and how to do it.

My requirement is to let my worker fill the data online and I can automatic use that to create the report. 

Any suggestion 

Thank you in advance 

Max

[v-juanli-msft]

Hi @Anonymous 

You have many files in a folder of Google Drive,

you need to connect to this folder with Power BI and combine and use data,

when data updates on Google Drive side, once click on "refresh" button, data in Power BI Desktop updates.

Is my understanding right?

If so, as a workaround, 

You could sync the files from Google Drive  to local disk, then connect to all the files in a folder with Power Query following the guide in the blog below.

http://www.howtoexcel.org/power-query/how-to-import-all-files-in-a-folder-with-power-query/

Best Regards

Maggie

Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

Hi @v-juanli-msft  

Which mean I have to click "refresh" button in power bi desktop and then click "publish"  if I want my team to see the report via mobile or website  right ?  

It couldn't be like auto refresh or something by powerbi service right ?   it has to be in desktop and click publish 

Thank again , I'm very new at this