Forum Discussion
Using Python Instead of Measures
Hey Anonymous ,
I would not consider it a shame, as DAX is a "query language", whereas python is a "general purpose" programming language of course with great data processing support eg. pandas, ... not to mention all the things possible if we are considering more advanced algorithms.
But DAX is designed to wade through billions, trillions of rows in real time, meaning a user changes the slicer selection.
Personally I'm / we are (at enterprise level) using python to create more "composed" visuals, where the composition is more important than the interactivity provided by the default visuals that are based on d3.js.
From an enterprise perspective we are not using python from within Power BI for data transformation directly, but of course python can be used together with Azure Databricks, providing tremendous possibilities :-)
Regards,
Tom
Much appreciated man. Great insight that you could tell I was doing this within my company. That's a shame about Python, and I'll need to commit to measure in DAX. In what instances would people use Python scripts within Power BI? For 1-off reports mostly?
Also, Hamburg is a great city, I lived there for 3 months in 2013.
Best.
Super UserHey Anonymous ,
I would not consider it a shame, as DAX is a "query language", whereas python is a "general purpose" programming language of course with great data processing support eg. pandas, ... not to mention all the things possible if we are considering more advanced algorithms.
But DAX is designed to wade through billions, trillions of rows in real time, meaning a user changes the slicer selection.
Personally I'm / we are (at enterprise level) using python to create more "composed" visuals, where the composition is more important than the interactivity provided by the default visuals that are based on d3.js.
From an enterprise perspective we are not using python from within Power BI for data transformation directly, but of course python can be used together with Azure Databricks, providing tremendous possibilities :-)
Regards,
Tom