nishalit's avatar
nishalit
New Member
6 years ago
Status:
Needs Votes

DAX R and PYTHON functions

Provide DAX functions that execute R and Python scripts. Similar to how you can insert an R or Python step in Power Query, allow a construct similar to: Column = VAR __MyVar = PYTHON("python code goes here") RETURN __MyVar This would open up a whole world of analytics and other capabilities and complete the tight integration of R and Python within Power BI

3 Comments

  • sue3's avatar
    sue3
    New Member

    It needs to go further, needs to allow for refreshing within the service not as a personal gateway

  • I just thought about the potential for this feature and checked to see if it existed yet as an idea. This could open a mind-blowing amount of analytical synergy between the high performance of analysis services and the endless statistical complexity of python. Imagine running a linear regression on a dynamic sample based on the filter context of the report or even the row context of the visual! The biggest problem I see would be performance issues. You would have to be very careful with your python code. I'm sure they could put in some processing power guardrails though, to keep measures using python from eating up all the resources. Not to mention they've already created similar functionality with Machine Learning Services in SQL Server. Great, great idea!

Recent ideas