@skai
The "Bind Parameter" option in Power BI Desktop's Power Query Editor is primarily used with DirectQuery connections to databases such as SQL Server, Azure SQL Database, or Analysis Services. It allows you to dynamically bind Power Query parameters to query parameters defined in your data source.
Unfortunately, the "Bind Parameter" option is not available for Python scripts or other data sources accessed through custom connectors in Power BI Desktop. Custom connectors typically do not support direct parameter binding in the same way as DirectQuery connections to databases.
However, you can achieve similar functionality by dynamically generating the Python script within Power Query using Power BI parameters. Here's an example of how you could modify your Power Query M code to achieve this:
```m
let
// Retrieve parameter values
starttime = #datetime(2022, 1, 1, 0, 0, 0),
endtime = #datetime(2022, 12, 31, 23, 59, 59),
// Convert parameter values to text
start_time_text = Text.From(starttime),
end_time_text = Text.From(endtime),
// Dynamic generation of Python script
python_script = "start_time = """ & start_time_text & """\nend_time = """ & end_time_text & """\n
# Your Python script here",
// Execute Python script
result = Python.Execute(python_script)
in
result
```
In this example, `starttime` and `endtime` are Power BI parameters defined in the "Manage Parameters" dialog. These parameters are then converted to text using `Text.From()`, and the Python script is dynamically generated by concatenating these text values into the script string.
This approach allows you to pass Power BI parameter values dynamically to your Python script within Power Query. However, it does not involve the "Bind Parameter" option, as it's not applicable to custom connectors like Python scripts.
Did I answer your question? Mark my post as a solution! Appreciate your Kudos !!
