Jan 08 2021 12:45 AM
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?
Jan 08 2021 11:16 AM
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.