Forum Discussion

Kopec's avatar
Kopec
Helper I
2 years ago
Solved

Call SQL procedure - redundant outputs

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