Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Button Event firing

Hi Experts,

 

I have several dropdownlist and checkboxes, i would like a button to execute some sql script based on the filtering criteria selected from those dropdownlist and checkboxes.

 

Questions:

1. Is it possible to stop any "event fired" or "data refresh" whenever data selected from dropdownlist or data checked in checkbox?

    because i only need data refresh when a button pressed once all dropdown/checkbox data selected, not everytime.

2. Can a button execute sql script?

 

Need Help

2 Replies

  • parry2k's avatar
    parry2k
    Super User
    6 years ago

    Anonymous I don't think there is out of the box that allows firing a SQL script but you can try to run Power Automate (Flow) on click of a button and make flow do the automation stuff. Read here.

     

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

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      Hi parry2k,

       

      In that case, can i have one button for page refresh once all data selected from all dropdownlist?

      Assuming i have 5 dropdownlist and i dont want page to refreshed each time a data selected from one dropdownlist, only refresh using the button, is this possible?