Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
I am also looking for a similar solution. What did you do? Thanks!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.