Call SQL procedure - redundant outputs

[Kopec]

Hi,

I insert parameters from excel cell to the SQL procedure by Power Query.

Outputs are Sql tables.

All works good, but It seems that PowerQuery called SQL procedure more than once. I have two sometimes tree redundant outputs in tables insted of one, if I call procedure by Power Query.

Do you anybody know why? Can anybody advise me, how to write it better?

Code:
Spolupracovnik = excel table with cell with parametr for Sql procedure
VZOK.VZOK = name of procedure

let
    Source = Excel.CurrentWorkbook(){[Name="Spolupracovnik"]}[Content],
    Spolupracc = Number.ToText(Source{0}[Column1]),
        query = "exec VZOK.VZOK '"& Spolupracc &"' ",
    target = Sql.Database("XXX_server number", "XXX_database name", [Query=query])
in
    target

Thank you,
Honza

[lbendlin · Accepted solution]

DO NOT DO THAT. Power Query is not a tool to write back into your data source!

Chris Webb's BI Blog: Why Is Power BI Running My SQL Query Twice? (crossjoin.co.uk)