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

     

aahmed's avatar
aahmed
Regular Visitor
9 years ago

faerewatson's avatar
faerewatson
Advocate I
8 years ago

aahmed - what if the Source "wheel" is non-existent (and when I right click, the "Edit Settings" is greyed out) - I can see this feature on some tables in my pbix file but not others. It seems as though the wheel/edit feature shows up if the query is ONLY referencing one table, but if the query has a JOIN then the wheel/edit feature is not available. Have you experienced this? Any suggestions for a workaround here? Editing the queries with the JOINs are the most cumbersome (I copy/paste into Notepad++ then "replace all" of the #(lf) and then reverse those steps after I've edited my query in SSMS.

  • rodneyc8063_1's avatar
    rodneyc8063_1
    Helper V
    2 years ago

    I know this is an older thread but I am also looking for an answer to this exact question currently, anyone have any documentation would be much appreciated 👍 

    • MattAllington's avatar
      MattAllington
      Community Champion
      2 years ago

      Click on Advanced Editor. I think it's available by right clicking the query pane on the left. If not, certainly in the menu