How to change SQL statement on an active Direct Query

[BaronSdG]

Hello everyone,

I have created a connection to an Azure DB. I used an SQL but now I need to update it. How to change SQL statement? The area is gray and doesn't allow me to change it.

[amitchandak · Accepted solution]

@BaronSdG , Open edit data transformation/edit query mode.

Right-click on table - Open the advance editor and check if the query is there.

Or check do you source there. Open the advance editor and check if the query is there.

Try to change there

[BaronSdG]

Yes is there, Thanks

But, the syntax is a bit different from the SQL statement I added as there is this term #(lf) in front of several Selects and other elements.