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!

User Group Leader Meeting January 768x460.png

Calling all User Group Leaders!

Don't miss the User Group Leader meetings on January, 24th & 25th, 2022.

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!

Top Solution Authors