getting external data from files in google drive and one drive

[seancsn]

I was wondering how I would connect Power query to csv files on google drive and one drive in the cloud and not on my desktop?
Thanks in advance

Sean

 

[ImkeF]

Hi Sean,
aren't they just a different filepath on your computer?
BR, Imke

 

[seancsn]

Hi Imke, Because the files are so large I dont synchronise with my home computer so this particular folder stays on the cloud.
Thanks, Sean

 

[ImkeF]

I think with Ken's approach you can tap the net as well: List all your URLs in the table and define in your function how to access on of it (in the PQ ribbon: Get external data - from Web)

 

[seancsn]

Sorry Imke, Im a bit of a novice. Would you be able to help me with the steps or point me to a link?
Thanks Sean

 

[ImkeF]

Would like to but just recognized that adressing the link doesn't give back a csv table but a html XML table. Unfortunately I have no idea where to identify the content we're looking for in there. Will have a look and come back if I've found sth.
BR, Imke