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