Forum Discussion

PZiaja's avatar
PZiaja
Copper Contributor
Jan 08, 2021

Modify query in existing data connection

Because year have changed I need to modify clause in existing data connection:

 

But I can't edit this sql query because "this connection was modified by Pover Query". In Power Query I'm able only to write new query which gives me result in new sheet that isn't connected with any table.
So here's the question: how can I modify an existing sql query in Pover Pivot or how to workaround this?

excel

1 Reply

  • SergeiBaklan's avatar
    SergeiBaklan
    Diamond Contributor
    Jan 08, 2021

    PZiaja 

    This connection was created or in Power Pivot, or, if by PowerQuery, when using From OLEDB connector.

    In first case open Power Pivot, select tab with this table, on ribbon Design->Table Properties, follow the menu.

     

    If it was created by Power Query you 1) shall see this query among others and 2) it shall be editable.

Resources