Forum Discussion

Anonymous

Not applicable

5 years ago

Solved

Measure with a Python Script

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
5 years ago
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.

3 Replies

amitchandak
Super User
5 years ago
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
  Not applicable
  5 years ago
  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.
Anonymous
Not applicable
5 years ago
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.