Connect GDrive with power Bi

Hi,

I want to connect google drive folder which conation many excel file and from those excel file i want to obtain one excel file .

As my scenario is like client will keep on adding file on drive for every month and the resultant file should be mereged of all files .

pls help with this.

Thanks,
Anurag

Hi @Anurag,

See if the technique described here is helpful in your scenario.
However I think you can expect challenges when it comes to scheduled refreshes. Switching to another cloud storage that does have a PQ Connector is something you should also consider…

I hope this is helpful

1 Like

Thanks for your guidance let you after going this is it helpful or not.

Another options would be to connect to Google Drive using Python or you create a single file inside Google by using Google App Script.

1 Like

Hi @Aurag , did the response provided by the experts above help you solve your query?

If not, how far did you get and what kind of help you need further?

If yes, kindly mark as solution the answer that solved your query.