Measure with a Python Script

[Anonymous]

A pickle file (with xgboost) needs to be used for a what-if analysis. Please help me create a measure with the python script. @python @xgboost @ML

[Anonymous · Accepted solution]

Hi @Anonymous 

DAX is a "query language", whereas python is a "general purpose" programming language of course with great data processing support eg. pandas. Power BI doesn't support you to use python as a query by measure(dax) directly. You can load the python scripts into Power BI and than query the data model by measure(dax) in Power BI.

For reference: Run Python scripts in Power BI Desktop

Best Regards,

Rico Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly. 

[amitchandak]

@Anonymous , You want to automate the proccess ?

Power BI Rest API and Power shell Cmdlets , but I doubt they have option to add measure. 

If you want to pass to pythong visual, you can add that to values

[Anonymous]

The output form the xgboost has to be passed through two regression models, for which measures can be created with coefficients, before the final output is generated for the user.