https://www.youtube.com/watch?v=lRYKb_yXkWQ
You need to install both personal gateway and standard gateway to set auto refresh in Power BI when used python script in power bi.take above link for reference