Trigger Python script from Power BI and get result in near-real time back to Power BI

[CCacho]

Hi all,

I want to create a filter in PBI that, when selected, it runs a python code to calculate a new table from my original data (whenever the filter changes, the table is updated). I already tried other ways like defining measures to do this calculation but it is to complicated to do it with them and that is why we need a python script.

Do you know an easy way to do this?

Thank you,
Catarina

[Anonymous · Accepted solution]

HI @CCacho,

AFAIK, visual filter effect and interaction should be more suitable to use Dax expression to handle. (e.g. isfiltered, isinscope)

Python visual can get filtered records but power bi does not include historical data features, so you can't directly use script to reproduce these filter interactions.

Regards,

Xiaoxin Sheng