MSPTDA 11: Power Query to Import from SQL Server Database in Excel or Power BI Desktop

Practice Problems: Assigned Homework:

In this Video learn how to connect to an SQL Server Database and extract and transform data using Power Query in Excel and Power BI Desktop.

Topics:
1. (00:16) Introduction
2. (00:32) What is an SQL Server Database
3. (02:19) The Goal of our Queries and a look at the end result reports in Excel
4. (03:04) Comparing and Contrast using 1) Using Power Query User Interface or 2) Writing SQL Code in Power Query
5. (04:46) Example 1: Use Power Query User Interface to connect to SQL Server and Extract, Transform and Load Data.
6. (11:27) Example 2: Write SQL Code to connect to SQL Server and Extract, Transform and Load Data.
7. (14:44) Example 3: Using Power BI Desktop to connect to SQL Server and Import multiple Tables.
8. (18:29) Summary

Comprehensive Microsoft Power Tools for Data Analysis Class, BI 348, taught by Mike Girvin, Excel MVP and Highline College Professor.

Thanks to Ken Puls and Miguel Escobar for letting me use their logo!!!!

[excelisfun]

Hint for the Password: E x c e l I s F u n:
E = Capital "E"
x = lowercase "x"
c = lowercase "c"
e = lowercase "e"
l = lowercase "l" = the letter after "k"
I = Capital "I" = the letter after "h"
s = lowercase "s"
F = Capital "F"
u = lowercase "u"
n = lowercase "n"
! = punctuation = "!" = exclamation point

[patrickbanzon]

Thank you Mike I have started from E-Dab and now I am at this video, I am so grateful (I am from the Philippines education is not cheap here) for your videos If I ever meet you in person dinner is on me.

[MrBlereau]

Looking forward to the SQLisFun channel 😀

[satx]

Great video Mike. Watching your videos is how this whole Excel/Power BI journey started for me. I haven't been working with Excel very long but utilizing your resouces and others has already put me in a class above and beyond really anybody else within the companies I've worked for. Everything you do is much appreciated.

[pkumara]

Thanks thousand times dear Mike for clear explanation. Your support to expand our knowledge can not be valued by money. I wish and pray for your good health and wealth.

[mohammedmohsinabbas]

Thank you so much for those great lessons each time I have hard time to solve something I find the best way to do it thanks to you

[Soulenergy]

This is a 5 star video Mike, You are making Thank you once again for such a great production and enlighting my self-learning curve!, God bless

[arteogr]

I do not know how to thank you, I have build a small database, thanks to your lessons, you have my 5 stars dish. Most valuable as always, something like a champion... Greatings from Crete.

[ljubicar]

I'm going to download SQL Server Management Studio right away and try to do this. So many things to learn! It is always fun watching your videos, thank you!

[davebowman]

What a great series of tutorials this is, I know people who are scared to death of or simply refuse to use any of the 'power' tools, they're missing so much.

[AsifAli-wsgg]

I dont know why google did not recommend me any video of this channel.

[alexjankowski]

Great video Mike. Thought it might have been a good idea for the video to point out the 'View Native Query' function in the UI to determine where query folding is enabled.
MSPTDA is an awesome series. I look forward to more!

[papeleria.]

For me, it's easier to write the SQL code rather than using the Power Quey interface, great video

[PRIYANKASharma-uvlx]

Please make a video on real life projects also how to submit them on GitHub. your teaching is helpful. Thanks

[andreasbeck]

I just wanna say, thank you so much for all your hard work, Mike!!! And I just feel like saying it again, and again, and again =)

[raitup]

Now I want to learn SQL with you as a teacher. Let us know when SQLIsFun YT Channel be ready...

[rajkumarpalle]

Thank you for sharing good information, ....I was wondering how to get the data with help of sql quires, into the power query. Now i got clarified. Thank you very much.

[amerfarooq]

so amazing information sir. thanks for each & every informative video

[tomr]

Great session! I have these down pretty well, PowerQuery, SQL, and PowerBI. Thanks again! Off to the next MSPTDA!

[JSUG]

Outstanding, as usual! Thanks, Mike for expanding all of our horizons!