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, MattAllington I don't know u got me wrong or i did...!!

I too follow the same SSMS way. But what um asking is, once um done with

1. writing SQL in SSMS and then Copying that SQL statement in

2. Get Data> SQL Server > SQL Statement Window,

3. Importing the data / Loading the data in the report (PBI Desktop) 

can i modify the query which i wrote at the get data in 2nd step...??:smileyhappy:

donsvensen's avatar
donsvensen
Skilled Sharer
10 years ago

Hi,

 

You can do that via the Applied Steps in your Query editor or using the advanced editor via the View tab and then modify your M/Power Query script

 

Or even better create a parameter and use that parameter in your query

 

/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