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

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


49 Comments

  • 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.

  • Dave Bowman

    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.

  • Giuseppe Confalone

    Mike, please by all means never give up your mission, even when there are people who do not know how to appreciate your work. That was another great tutorial and explained so many things I was trying to figure out by myself. And the fun I went through today: I actually successfully got connected to the pond.highline.edu database. Thanks so much for this opportunity. Greetings from one of your greatest fans :-).

  • aru aru

    Hi Mike, Thanks for your wonderful videos. As always, your work inspire me a lot while processing a lot of data set and reports. Thanks and really appreciate your works!! I've tried to access the DB but got "Unable to Connect" error  "Details:MicorSoft SQL: The target principal name is incorrect. Cannot generate SSPI Context. I did use "pond.highline.edu" and "boomerang" DB. Is there any restriction to access it?  Thanks !!

  • Bart Titulaer

    Thanks Mike, I have seen/heard the term "Direct Query" so often but this is the first time I really understand. You can learn Excel and Power BI with books and internet but for SQL it is a bit more difficult. Thanks for presenting this so clearly.
    One question: in the SQL example you did not enter credentials why? Because you did this in the first part?

  • Excel.i Adam

    Connection to the database that someone created is simple 😀
    Now I'm trying to create a database like yours so that I can connect to it and it turns out to be difficult for me 🙁

  • ExcelIsFun

    If you want to practice what you learned in this video, check out the practice problems (homework) provides in the links below the video : )

  • Alex Jankowski

    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!

  • jazzista1967

    Excellent Video Mike. I was hoping that you would open the SQL Management Studio and write the SQL statement . Look forward to the next videos. Thanks for all your insights

  • Geert Delmulle

    Mike, some files can not be downloaded:
    – "Excel FINISHED File" => Page Not Found error
    – "Example of Finished Homework" => actually yields the Start File
    Can you please fix this?
    Thanks!

  • M. SZ.

    Thank you for the next instalment in this series, Mike. Yes, the finished files are somehow corrupt/missing. Thank you for looking into it later.

  • nathan451

    Hello Mike, thank you so much for your brilliant videos. It’s so helpful. Just a question: could there be a performance difference between the 2 methods (power query UI vs SQL code)? Thanks again for all you give to the XL/BI community. And greetings from Paris. Nathan.

  • Saul Espinoza

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

  • Neighborhoodhomeinvestment.com

    Please do you know how to formulate the following condition in excel; when you have two cells one with high and the other with low value and one of the cell is colored green. so you want to return a value of '1' if the lowest value amoung the two cell is green color and '0' is the highest value amoung the cell is green. is there a condition or formula for the statement in excel

  • DIGITAL COOKING

    please question mike, we know that creating a measure with DAX is better than column whenever it's possible
    but what about creating a column with power query compare to :
    1) creating a column with DAX ( because I have an idea that with power query is better )
    2) creating a measure with DAX do the same calculation with a column created with power query
    hope you understand my question
    beside the question, you did very well video mike, and for me, I learn a lot of stuff in your channel
    believe me, I was lost before and didn't even know where to start and how to finish….now i found my path and know very well
    how to study efficientely

  • David Heslop

    Mike, thanks, this is fantastic. Wanted to say thanks as the last few months your guidance in excel and power query has helped so much.

    One thing I noticed in this video was the "include relationship columns" which looks amazing. Should this work exactly the same if my source is an Oracle database rather than a SQL database? I cannot seem to get this to identify related columns even though I know they exist between my source tables. Apologies if you've covered this elsewhere! Thanks David

  • Ogwal Francis

    This is an amazing video, i want to inquire how to copy or export visualisation from power BI to word document and to excel,

  • Isaac Hernandez

    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.

  • Fernando Domínguez Martín

    Y si la BBDD SQL está en un entorno remoto y no podemos conectarla por nombre? ¿Cómo conozco la IP o consigo que lo sepa por el nombre? ¿Cómo configuro esto para todos los usuarios de OneDrive de la empresa que disponen en sus espacios OneDrive Excel que conectan con un SQL Server?

  • ExcelIsFun

    The Power Query logo used in this video is copyright of and used with the express permission of https://powerquery.training

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

  • Tik Tok

    Thank you for great video, but can u conclude which way is better to get data from SQL database? Because English is not my native language, I don’t understand u at some point 😢. But I’m still following this course 😊

  • zhang lei

    I cannot connect to the SQL which shows: Details: "Microsoft SQL: The target principal name is incorrect. Cannot generate SSPI context."

  • Jeff Kasavan

    Is the server still online? I get this error:
    DataSource.Error: Microsoft SQL: A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 – Could not open a connection to SQL Server)

    Details:

    DataSourceKind=SQL

    DataSourcePath=pond.highline.edu;boomerang

    Message=A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 – Could not open a connection to SQL Server)

    Number=53

    Class=20

  • 김고운

    If i want to utilize parameter table for the options of server and sql statement description, how to link the table? I tried to use the same way of the parameter table to link folder path(folder.files -> odbc.query (“dsn=server name”, “sql statement reference query connection”), but I fail for this way.. Could you help me how to solve this issue so that I can easily select odbc server and modify sql statement from the excel work sheet (not by query edit window)?

Leave a Reply

Your email address will not be published. Required fields are marked *