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.
Find the way. In Table properties.
Yup, pls. let me know if you have assiciated question.