How to edit an existing direct query?

[ShrikantKhanna]

Hi,

I need help with editing an existing direct query that I have via ODBC. I have to call in another data column using the same query. 

I have some calculations running using the existing query so I cannot afford to delete and start over again.

Is there a way?

[Anonymous · Accepted solution]

If you entered in the query explicitly in the "Advanced Options" when importing the data, you can get right back to that dialog box.

Click "Edit Queries":

Go to the query you want to modify, and hit the settings cog near "Source":

From here, you can write in whatever you'd like.

[Anonymous]

Thank you.

[ShrikantKhanna]

Thanks.

[ShrikantKhanna]

Thanks.