none
power query or direct t-sql querying RRS feed

  • Question

  • Hi,

    I need to access and manipulate some data that are held on a SQL server and not sure whether to use power query for this or query the database directly through sql management studio. Aside from the obvious differences in terms of look and feel, what are the pros and cons of the 2 approaches and does it make a difference regarding speed and efficiency etc?

    Thanks in advance.

    Ben

    Tuesday, January 13, 2015 11:33 AM

Answers

  • Generally speaking, Power Query will allow you to get the data into a shape that you want more quickly but this can be at the expense of performance since Power Query may not generate the most optimal T-SQL query. Writing your T-SQL directly will enable you to squeeze as much performance as possible out of the query (depending on your level of skill) but this is at the expense of taking longer to write a query to get the data into the desired shape. In addition to what has been mentioned, as Power Query shows you a preview of the data as you make changes, you can more quickly identify whether a given set of manipulations will yield the correct output. There are more pros and cons but these are probably the most polarising ones in regard to speed and efficiency.


    Regards,

    Michael Amadi

    Please use the 'Mark as answer' link to mark a post that answers your question. If you find a reply helpful, please remember to vote it as helpful :)

    Website: http://www.nimblelearn.com, Twitter: @nimblelearn

    Tuesday, January 13, 2015 8:35 PM
    Moderator