Editing data source settings

[TimothyNL]

Hi, 

I have recently started using powerBI in an attempt to set up some reporting, I have set up a data source connecting to our redshift datalake, because I was just experimenting I have set pretty rigid parameters to my input queries like using a hard date rather than some function that takes last 6 months of data or whatever. 

Now that I built my report and tested that everything is working and look as intended I try to go back to my data source to edit the query a little bit to change certain parameters so that it always looks back 6 months rather than using a fixed date. 

To my surprise I am unable to edit the query, all the text is greyed out and I am not seeing any option or checkbox to change this. 

How do I edit this input query? 

I ran into this problem once before in the very beginning but at that stage I was only using select top 100 * statement and at that time I just shrugged it off and opened a new blank report and started from scratch, now however I am having a 15 page report with like 50 visuals so I'm kind off keen on editing the existing data source and not starting from scratch again. 

[danextian]

hI @TimothyNL 

Go to the query editor and edit the highlighted strings.

[TimothyNL]

Oh so you are saying just change it there.

I will give it a shot, im just noticing in there that there are extra characters in the string that I did not put there, I assume this is powerBI formatting doing this, 

So Im thinking for the specific parameter I want to update: 

If I just update the text between #(lf) there it will stay functional? 

[danextian · Accepted solution]

#(lf) means line feed because when you entered your script they were separated by line. The script if correct will still run nonetheless. But I would edit that in the advanced editor for a bigger space plus line feeds are not replaced with #(lf). Alternatively, if there's an existing view with the same query, I would connect to that instead.