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

     

Anonymous's avatar
Anonymous
Not applicable
10 years ago

hi donsvensen um not aware of M/Power Query Script and i got a few modfications in my query through updating the previous SQL statement in SSMS. i want to use the updated SQL instead of the SQL i provided to the report before.

should i create another data connection and add another query to the report with the updated SQL is this the only choice do i have..??

or

is there anyway to update the old SQL of the Existing Query..?

donsvensen's avatar
donsvensen
Skilled Sharer
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

 

  • aminebelghazi's avatar
    aminebelghazi
    Regular Visitor
    10 years ago

    Hi, 

    I tried changing an SQL statement changing the source; but the SQL statement area is greyed out (impossible to change the text).

     

    Thanks for your help