Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

power query python script and slicers not properly interacting in report

Hello,      I have python visuals in a report that contain the scripting right in the visual the way it normally would be done. I also use a pythonscript to run a statistical regression being on dat...
Need Help
  • TomMartens's avatar
    TomMartens
    7 years ago

    Hey,

     

    you have to rethink your current solution, a  Power Query (no matter if it contains python script or not) is only "executed" if the data is refreshed and not if the selection of a slicer is changed. This will only affect the number of rows meaning, tables are filtered. A visual just represents the filtered table, but the table will not be recalculated, this is also valid for calculated columns created by using DAX statements.

    Only measures are "recalculated" if a user interacts with the data model.

     

    Regards,

    Tom

TomMartens's avatar
TomMartens
Super User
7 years ago

Hey,

 

you have to rethink your current solution, a  Power Query (no matter if it contains python script or not) is only "executed" if the data is refreshed and not if the selection of a slicer is changed. This will only affect the number of rows meaning, tables are filtered. A visual just represents the filtered table, but the table will not be recalculated, this is also valid for calculated columns created by using DAX statements.

Only measures are "recalculated" if a user interacts with the data model.

 

Regards,

Tom