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

No video

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

Рет қаралды 47,921

Күн бұрын

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:
• Animate Moths in Blend...
In any event, now you know how to work with Excel data in Power BI.

Пікірлер: 26

@jessehamburger2391 Жыл бұрын

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.

@LashanR 3 жыл бұрын

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

@SaniGarba 3 жыл бұрын

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

@BIPolarSSBI 3 жыл бұрын

I'll do my best - thank you!

@rosswaterston 3 жыл бұрын

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

@BIPolarSSBI 3 жыл бұрын

Thank you!

@wesleyharper3253 Жыл бұрын

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

@jessehamburger2391 Жыл бұрын

Because nothing works the way it should T_T

@Nick.Anselmo 3 жыл бұрын

My favorite Matthew Roche Production thus far!

@BIPolarSSBI 3 жыл бұрын

They'll only get worse from here, so you should probably unsubscribe now, just in case.

@Henrik.Vestergaard 3 жыл бұрын

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

@BIPolarSSBI 3 жыл бұрын

If this was the highlight of the day, I had a pretty good idea that the rest of your day wasn't that great. ;-)

@CTMusic-xg7sh 4 ай бұрын

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

@elijahzhao6251 Жыл бұрын

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

@TalmadgesArcade Жыл бұрын

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

@elmirojunior9843 Жыл бұрын

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

@Urena10924 Жыл бұрын

Thank you, this was killing me!!!

@krishnakishorepeddisetti4387 2 жыл бұрын

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 ?

@jfcchute Жыл бұрын

Yes, I have this same request as well! How do we connect to a sharepoint folder?

@JM-mz1zj 8 ай бұрын

❤

@bilelk2388 3 жыл бұрын

Why i have "DataSource.Error"?

@spilledgraphics 3 жыл бұрын

ABBA ? :D

@BIPolarSSBI 3 жыл бұрын

ABBA is a Swedish pop supergroup formed in Stockholm in 1972 by Agnetha Fältskog, Björn Ulvaeus, Benny Andersson, and Anni-Frid Lyngstad. The group's name is an acronym of the first letters of their first names. They became one of the most commercially successful acts in the history of popular music, topping the charts worldwide from 1974 to 1983.

@SmartTalks007 Ай бұрын

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