Forum Discussion

Anonymous's avatar
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
Need Help
  • Anonymous's avatar
    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. 

     

     

amitchandak's avatar
amitchandak
Icon for Super User rankSuper 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's avatar
    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.