Power BI to trigger KNIME workflow

Hi,

I am working on an activity where I have a workflow that uses an SQL server as its source. After transforming the data through many nodes, it writes an excel sheet which is visualized in Power BI.

The SQL script has 3 variables going into it: starttime, endtime, and name.

Currently when I run this workflow, I choose the starttime, endtime, and name (in KNIME), run the workflow, and refresh the power bi.

Is it possible to do all of this from Power BI? I mean, that a user on Power BI chooses a starttime, endtime, and name (from a list slicer), and then these are sent to knime and are used 1. as inputs in the workflow and 2. trigger the workflow automatically?

This way all of the configurations are made only from the powerbi user interface. ie. the user doesn’t need to touch KNIME.

Thank you!