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

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


Danny Hutson

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

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

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

  3. 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 :-).

  4. 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 !!

  5. 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?

  6. 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 🙁

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

  8. 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!

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

  10. 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!

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

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

  13. 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!!!!!

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

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

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

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

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

  19. 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?

  20. 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!!!!

  21. 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 😊

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

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

  24. 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 *