Trigger python web scraping script with automatic refresh

[simber]

I have a report with two data sources. One is a excelfile which orignates from data that is webscraped with a python script (using beautifulsoup and selenium). The other is from an oracle database. The report have an automatic refresh/ scheduled refresh (with the on premise gateway), which updates the data from the oracle database.

Is it possible to trigger the python script when the automatic refresh is triggerd? thus updating the source excelfile.

[amitchandak]

@simber , You can write down a code in python table source and when schedule refresh for that, if will run that code again, that should work.

Refer this example

https://www.biinsight.com/exporting-power-bi-data-to-sql-server/