How to run python script.

[SourabhSharma]

HI All,

I am new to power bi.

I want to run python scripts in power bi.

I can see online there are tutorials in which they shows how to link to python script and all.

May i know if there is a way to run python script in power bi browser mode ? 

if yes can you please share any refference document that I can refer.

[Chwayita-Momoza]

When you publish a report to Power BI Service (browser mode), the Python scripts are not executed there. However, you can still utilize the Power BI Service to refresh and update data in the report, which may involve running the queries and transformations defined in Power BI Desktop, including those involving Python scripts.

[Greg_Deckler]

@SourabhSharma Not sure what you mean by "browser mode". If you are talking about running Python when in the Power BI Service then that should work. You can use Python in Power Query or use the Python visual to run Python. Both should work in the Service. Which one are you doing?

[SourabhSharma]

HI @Greg_Deckler 

by browser i mean by using the link https://app.powerbi.com/

and I am not sure that you are also reffering to the same or not ?

if yes then where can I find the option that you mentioned.

[v-yiruan-msft]

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

[SourabhSharma]

Thankyou @v-yiruan-msft 

definitely this is really helpful.

is there a way to automate this as well ? 

like is it possible to publish the report automatically as well ? 

just in case there exists any APIs to achieve the same ? 

And also I could see there are some limitations of running python script directly to the power bi and then generate the report. may I know if there exist API that we can use to publish the report directly ? rather then creating it on powerBi ?

[marcoperson_250]

Thank you for sharing valuable insights.

These four points are help for me. @v-yiruan-msft