Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
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.
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.