Date range as input for Python script

[Anonymous]

Hi everyone,

I'm fairly new to PowerBI and I'm wondering if there's a way that I can pass a date range that the user will define (start date & end date) for a Python script of mine that will perform a query and retrieve a dataframe with data between those dates.

I know that you can copy and paste a Python script inside PowerBI but I need to change the dates on the go and perform new queries as the user changes them.

Any help is really appreciated!

[lbendlin · Accepted solution]

Yes, that is standard functionality. The Python visual expects you to provide source data into the initial dataframe (in your case the start and end date) but then you can create an entirely different dataframe etc.  Note that the Python visual expects you to plot something at the end.  Also note that the Python script in Power Query expects a table and is expected to return a table.