Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Automatic append file from Googledrive

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 worke...
Need Help
v-juanli-msft's avatar
v-juanli-msft
Community Support
7 years ago

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's avatar
Anonymous
Not applicable
7 years ago

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