How to update Excel file

Hello, 

I use python script to fetch data from API and load the data to excel sheet, Is there a way that i can refresh my data from Power BI after i load the data ?

How can i make an excel source to be dynamic and to response to 'refresh' in Power BI?

Thank you.