Forum Discussion
Editing data source settings
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.
#(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.
3 Replies
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?
#(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.
