Modify query in existing data connection

%3CLINGO-SUB%20id%3D%22lingo-sub-2042812%22%20slang%3D%22en-US%22%3EModify%20query%20in%20existing%20data%20connection%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2042812%22%20slang%3D%22en-US%22%3E%3CP%3EBecause%20year%20have%20changed%20I%20need%20to%20modify%20clause%20in%20existing%20data%20connection%3A%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22PZiaja_0-1610095405709.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F244863i108949E3C1C8669F%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22PZiaja_0-1610095405709.png%22%20alt%3D%22PZiaja_0-1610095405709.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EBut%20I%20can't%20edit%20this%20sql%20query%20because%20%22this%20connection%20was%20modified%20by%20Pover%20Query%22.%20In%20Power%20Query%20I'm%20able%20only%20to%20write%20new%20query%20which%20gives%20me%20result%20in%20new%20sheet%20that%20isn't%20connected%20with%20any%20table.%3CBR%20%2F%3ESo%20here's%20the%20question%3A%20how%20can%20I%20modify%20an%20existing%20sql%20query%20in%20Pover%20Pivot%20or%20how%20to%20workaround%20this%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2042812%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2044473%22%20slang%3D%22en-US%22%3ERe%3A%20Modify%20query%20in%20existing%20data%20connection%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2044473%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F922033%22%20target%3D%22_blank%22%3E%40PZiaja%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EThis%20connection%20was%20created%20or%20in%20Power%20Pivot%2C%20or%2C%20if%20by%20PowerQuery%2C%20when%20using%20From%20OLEDB%20connector.%3C%2FP%3E%0A%3CP%3EIn%20first%20case%20open%20Power%20Pivot%2C%20select%20tab%20with%20this%20table%2C%20on%20ribbon%20Design-%26gt%3BTable%20Properties%2C%20follow%20the%20menu.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EIf%20it%20was%20created%20by%20Power%20Query%20you%201)%20shall%20see%20this%20query%20among%20others%20and%202)%20it%20shall%20be%20editable.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

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

PZiaja_0-1610095405709.png

 

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?

1 Reply

@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.