Showing results for 
Search instead for 
Did you mean: 
New Member

How to use dynamically filtered database in a python script

I'm doing an analysis that takes a subset available from my Power BI data source and generates a table using python (which performs complex calculations).

But my question is about how to bring filtered data into the Python script.

I'm using the query transformation, which has a Python script option to generate my calculation.

The problem is that when I use the filter panel (inside the panel), the Python script is never updated and the data is still wrong.

I tried to use Visual Python, but I don't want to see the Python graphs, I need to use the python data to then visualize it in the Power BI graphs.


I've looked for several solutions, but I can't get it to work.


For example, here is a code I need to run:

# The data must be filtered before applying my python script

dataset['SMA'] = dataset.VALUE.rolling(2, win_type='gaussian').sum(std=3)

# After that, I need to show using Power BI charts


New Member

I am also looking for a similar solution. What did you do? Thanks!

Helpful resources

Power BI December 2021 Update_carousel 768x460.jpg

Check it Out!

Click here to read more about the December 2021 Updates!

Jan 2022 Dev Camp 768x460 copy.png

Power BI Dev Camp- January 27th, 2022

Mark your calendars and join us for our next Power BI Dev Camp!

UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Top Solution Authors