How to connect to an Excel or CSV File on SharePoint / OneDrive using Power Query

The quickest way to use Power Query to connect to an Excel or CSV file on SharePoint / OneDrive

Did you know I've written a book "Power BI for the Excel Analyst"?

Connect with me

[excelisfun]

Killer tip!!!! Why does Microsoft making everything so hidden or hard ? lol Thanks, Wyn!!!

[eals]

This was a perfect solution to what I needed. Thank you!

Why did Microsoft bury this in such a weird place?

[florianboissiere]

2 years later and you're still saving us from heaps of headaches with this awesome technique. Thanks so much for sharing!

[mvanderwalt]

Fantastic video. To the point and exactly the information I needed. Thank you!

[heshamfouad]

Perfect, exactly what I was looking for in a less than 3 minutes video
Thanks so much

[Soulenergy]

An unbeatable version of this action!!!! thank you very much once

[Vandalfoe]

Yay. Thanks for a much quicker way. I used to have to open online, then load to desktop, then get the file path from backstage or whatever its called when you click on "file" in excel. CHEERS!

[tnchv-a]

Your videos have always been helpful. Thank you!

[nolanbridges]

This saved me when working with Power BI! Thank you SO MUCH

[yewchoob]

Really good video. Spot on.

Fast explanation, no bollocks.

Cheers butt.

[alistairmonro]

I spent far too long trying to work this out myself, thank you!

[dammaksalma]

you just saved my day I have been looking for this in the last 5 days thank you

[marcusl]

Finally a video that solves all my headache. Thank you very much!

[carloscantu]

Very useful and straightforward explanation, thanks for sharing!

[ayvep]

Thank you for this update, a very useful bit of information!

[jorgeantoniobasurtoramos]

I thought that it wasn't working for me, but I found my organization SharePoint and it's already done. Thanks so much for this update!

[tonyrk]

Thanks. I'm preparing for a new role and your tips are life savers!

[janbever]

Great tip, exactly what I was looking for!

[pedroviniciuspereirajunho]

Only if you knew how much it helped me!

Thanks man, nice job!

Very very useful! Thansk a lot Wyn, these tips are really appreciated :)