Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Using Power BI variable in Python Script

Hi there,

 

I was trying to see if we could run a Python script in PowerBI using a PowerBI variable as part of the script.


For instance, the script would be:

print({Sum of Sales Variable})

 

The end goal is to have a Predictive model written in Python that runs within PowerBI based on input parameters from the dashboard. That way the business user would just have to select an input value, click "refresh" and the model would re-run using that input value. Then the visualizations would get updated on their own.


Any advice on how to do that?

 

Thanks!

Show and Tell
Tips and Tricks

2 Replies

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

      Thanks, v-chuncz-msft . 

       

      I have tried it and was able to use the parameter there, but I want to use the PowerBI visualizations. 

       

      Can you re-integrate data frames from the Python viz as PBI data table? Or is there a way to integrate the parameter into the Python script when loading data tables?

      Thanks!