Can I update the query statement in an existing connection?

Question

I add connections to SQL Server with sql query in Powerpivot.

My question is can I update the query statement in an existing connection?

I can do that in pivot, but do not find the way to update an existing sql query in powerpivot.

It will create a new query with new tab in powerpivot every time.

---

new guy in the wm world

Answer 1

Find the way. In Table properties.

Thanks.

---

new guy in the wm world

Answer 2

Yup, pls. let me know if you have assiciated question.