Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
10 years ago
Solved

Edit Existing SQL

Hi All,   Once i import data through Get data> SQL Server > providing the query in the SQL statement window, is it possible to modify that SQL...? (a SQL with complex calculations for our requireme...
Need Help
  • donsvensen's avatar
    donsvensen
    10 years ago

    You can modify it by clicking on the wheel on the source Step in the query settings

     

     

    or modify the Query parameter in the Advanced editor

     

    /erik

     

MattAllington's avatar
MattAllington
Community Champion
10 years ago

Power Query has a "split query" option to break a query into 2 pieces.  hence you can break your query into a "source" and then transformation this way.  Then you can point to the new source and create a new query from that.

 

In my experience, I tend to write my queries in SSMS first, then paste them into the Query window when creating a new query. I find it easier and more flexible.  The only exception is if you want to use Query Folding with a table from within Power BI, then it is better to use a native query.