KNIME autorefresh

[lahiru_ten]

I’m fairly new to KNIME but I was wondering if there is a way for a KNIME workflow to update the input file itself periodically.

I’m creating a dashboard in power BI and it uses information from several excel trackers that get updated daily. I’ve done the data transformation and that will be the data input for Power BI. Is there a way for KNIME to automatically refresh the workflow either on a daily or weekly basis so the Power Bi dashboard is displaying up to date information?

[Daniel_Weikert]

This would work with KNIME business hub which is a commercial product. Is there a reason why you use KNIME instead of the build in Power query editor. Then it would work out of the box.
br

[lahiru_ten]

Hi Daniel,

Appreciate the response. My first iteration did use power query editor however, Power BI became quite laggy. I’ve got maybe 10-20 excel trackers with numerous sheets within those files and this is for one project. The dashboard is meant to cover 10+ projects. So I thought, lets do the all the transforming in KNIME and load that into Power BI so it only deals with the visualisations. This is more of a short terms solution whilst a CDE is created.

[iCFO]

Executing a Query periodically

Hi Everyone, First time KNIME user here. I am trying to extract some data from a postgres server and parse it. First I want to be able to pull the data at periodic intervals. I tried researching online and came across loops and wait nodes, but none of the solutions really work for me. I am not planning on using KNIME Webserver due to its very high cost. is there a way i can execute the query in a periodic manner say every 15mins etc? I cant seem to even execute the nodes manually unless i …