Forum Discussion
Solved
SQL script runs twice after changing parameters
Hi, I am running a SQL script from power bi with user parameters. When the parameters are changed the script seems to be running twice. I've seen some posts with similar issue but haven't found a ...
mq2020 instead of having a script in pq, load view/table from the backend filter the table with a parameter, and with query folding it will send back the query to backend.
I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos whoever helped to solve your problem. It is a token of appreciation!
⚡Visit us at https://perytus.com, your one-stop shop for Power BI related projects/training/consultancy.⚡
I think this blog post might be able to help.
https://blog.crossjoin.co.uk/2020/07/05/why-is-power-bi-running-my-sql-query-twice/
