Connecting to Excel in SharePoint Online from Power Query (Lazy Tutorial)

Is connecting to an Excel workbook in SharePoint Online from Power BI starting to feel like your Waterloo? Why not surrender to this lazy tutorial?

Yes, I am totally stealing this awesome/lazy format from the incredible and talented Ian Hubert. If you want to see how an actually professional does things, you should check out this one:

In any event, now you know how to work with Excel data in Power BI.

[jhanawa]

6 hours beating my head against the wall. 30 seconds of your video fixed my issue! Thank you.

[jessehamburger]

This literally just saved me hours of stumbling around blindly and praying that the support forums would bless me with an answer buried on the 10th page of Google. You're a hero.

[SaniGarba]

Please give us more of this “snarky” videos. They are endearing. Thanks.

[LashanR]

This is so snarky but it actually taught me everything I needed to know

[rosswaterston]

Absolutely AMAZING video, I nominate this video for an Oscar! Keep it up Matthew!

[Henrik.Vestergaard]

The highlight of my day. Great laugh. My day was so-so

[wesleyharper]

Why is this video more helpful than sophisticated 30 minute guides?

[Nick.Anselmo]

My favorite Matthew Roche Production thus far!

[elijahzhao]

Man YOU are AMAZING!!! Thanks a lot! It helped save a lot of time.

[CTMusic-xgsh]

Thank you so much! I can't believe this is still so hidden.

[TalmadgesArcade]

yeah what that guy said 2 months ago - THANK YOU FOR

[elmirojunior]

Muito bom! Solucionou meu problema de consulta do Power Query X Sharepoint

[krishnakishorepeddisetti]

amazing video....what if i have more than 1 excel file in the folder and i want to import all of them together ?? any suggestions ?

[bilelk]

Why i have "DataSource.Error"?

[SmartTalks]

Working in a online excel file is the worst experience shaerpoint can provide. Shortcuts dont work, sheet lags like shit absolutely 3rd classs experince!