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 worker fill the data online and I can automatic use that to create the report. 

Any suggestion 


Thank you in advance 

 

Max

Need Help

2 Replies

  • 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