Forum Discussion
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...
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.