Power Bi can call python script?

Hi pennyhoho117,

Thank you for reaching out to the Microsoft Fabric Froum Community.

I understand that you are experiencing an issue where your Power BI report (PBIX) containing a Python script runs locally but fails in Power BI Service due to a gateway configuration error. Additionally, you are inquiring whether Power Automate Cloud can execute a Python script stored on an on-premises server via the on-premises data gateway. 

Allow me to address both of your concerns: 

1. Power BI Desktop supports Python scripts. However, when published to Power BI Service, Python scripts need a Personal Gateway instead of an on-premises data gateway. The on-premises data gateway does not support Python execution in Power BI Service, which is why you are encountering a gateway-related error.   
2. Power Automate is unable to directly run a Python script via the on-premises data gateway. 

• Utilize Power Automate Desktop to execute Python scripts on a local machine.
• Power Automate Cloud is unable to run Python scripts directly through the on-premises gateway. Instead, consider using Azure Functions or triggering the script indirectly. Power Automate Desktop can execute local Python scripts.

Please refer to the link below for a better understanding: 

Use a personal gateway in Power BI - Power BI | Microsoft Learn 

Use Python v3 in Power Automate for desktop | Microsoft Learn 

If this post helps, then please give us ‘Kudos’ and consider Accept it as a solution to help the other members find it more quickly.   

Thank you.