How to run python script.

Hi SourabhSharma ,

Currently, Power BI service does not support running Python scripts directly in Power BI Service. You can create Python visuals in Power BI Desktop, and these visuals will be displayed in Power BI service when you publish your report. You can follow the steps below to get it:

1. Install Python on your local machine and make sure it is compatible with Power BI service. You can download Python from the Python website You also need to install two Python packages: pandas and matplotlib, which are essential for working with data frames and plots in Power BI.

pip install pandas
pip install matplotlib

2. Enable Python scripting in Power BI Desktop by selecting File > Options and settings > Options > Python scripting.

Run Python scripts in Power BI Desktop - Power BI | Microsoft Learn

3. You can refer the following links to create Python visual or run Python script:

Use Python visualization:

Python visualizations in Power BI Service | Microsoft Power BI Blog | Microsoft Power BI

Run Python Script:

How to Run Python Script in Power BI - Zebra BI

Running Python Scripts in Power BI Tutorial | DataCamp

4. Pulish the repor to Service

However, there are some limitations or considerations in using Python with Power BI:

• Data sources added with Python must be set to public.
• Only Pandas DataFrames can be imported into Power BI using Python.
• Scripts that take longer than 30 minutes to run will time out, as will Python visuals that take more than 5 minutes to run.
• There are a limited number of Python libraries supported by Power BI Service. 
• Reports using Python can only be refreshed in Power BI Service through a personal gateway (the enterprise or standard gateway is not supported).
• Python visuals do not support cross-filtering. This means that selecting an element in a Python visual will not cause other visuals to filter by that selection, thus removing some degree of interactivity in the Power BI report.

Best Regards