Make Parameters in Python as the User Input in Power BI

[vika_cheng]

Hi everyone,

I currently have a Python script designed to generate a basic report for ANOVA analysis. Within this script, I can modify parameters in Python (e.g., date range, data source, metric etc.) to extract the necessary data and perform the analysis. I am wondering if it's feasible to enable users to dynamically select these parameters within Power BI. This would ensure that the data input to Power BI is adjusted accordingly based on user preferences.

Best regards,

Vika

[Anonymous]

Hi  @vika_cheng ,

Unfortunately, Power BI does not natively support dynamic user input for parameters within the Python script execution itself. However, there is a workaround using Power Query:

1.Create Query Parameters.

2.Invoke Python Script with Parameters:

• Still in the Power Query editor, you can invoke a Python script by adding a new step with the Python script option.
• In the Python code, retrieve the parameters from the Power Query environment and use them in your script. Here's an example:

  import pandas as pd
  
  # Assuming 'date_range' is a parameter from Power Query
  date_range = ... # Replace with code to get parameter from Power Query
  
  # Your Python code that uses the parameter

After you apply the changes, the Python script will run using the parameters set in Power Query.

Please refer to the following documents for more information.

Dynamic M query parameters in Power BI Desktop - Power BI | Microsoft Learn

Top use cases for dynamic data parameterization in Power BI - Neal Analytics

Creating Dynamic Reports with Power BI: Using Parameters and Variables (skillzcafe.com)

Best Regards,

Neeko Tang

If this post  helps, then please consider Accept it as the solution  to help the other members find it more quickly.