Good morning,
I am trying to modify an existing query in powerpivot (it seems like I always forget that one important field), but I can't find a way to modify the existing query-only create a new one based upon an existing connection.
If I click on existing connections (design tab) and find the correct connection, open it and choose write a query, it only allows a new query to be created-not a modification of the existing (if I try to reuse the original name, I get a "friendly name error").
Is it possible to modify a query, so I don't have to re-create all my relationships, measures, etc...? And if so, any help on how would be greatly appreciated.
Thanks,
David
I am trying to modify an existing query in powerpivot (it seems like I always forget that one important field), but I can't find a way to modify the existing query-only create a new one based upon an existing connection.
If I click on existing connections (design tab) and find the correct connection, open it and choose write a query, it only allows a new query to be created-not a modification of the existing (if I try to reuse the original name, I get a "friendly name error").
Is it possible to modify a query, so I don't have to re-create all my relationships, measures, etc...? And if so, any help on how would be greatly appreciated.
Thanks,
David
