Data Science

Unleash Python within Microsoft Power BI Desktop

We have all seen the amazing things Microsoft is doing each month with Microsoft Power BI updates. I’ve been working in the Microsoft ecosystem for 20 years now, and I’ve never seen an update frequency like the one we see with Microsoft Power BI and the Power Platform in general. These updates are not trivial either and they usually span across several areas of Power BI itself. With the recent August update, Microsoft has now giving us the ability to host, render and use Python script for visuals and within PowerQuery (M) for loading data frames into Power BI data sets. With this, we now have a great choice of either R Script visuals or Python Script visuals to help us craft more advance data stories. This includes such stories that would be descriptive in nature, but also moving more and more into the forecasting and predictive / prescriptive models. With this new Python visualization option, it is super important to understand now what does this bring to the table for crafting stories? What are the current limits? What is the perceived and known road map for Python being valid target for effective data stories in Power BI? To get this started let me state my sheer excitement around this news and release. I have used Python a good bit in my past endeavors. It is one of the most flexible languages in the wild, with the abilities to help craft data stories, mobile, web and general app development needs. It can execute and be hosted across all the major platforms, from Windows, Linux and MacOS. I would dare say, only JavaScript, holds a real candle to having such a wide range of useful targets to work in. Now lets dive into Python for Power BI, how to set this up and getting started within using it with Microsoft Power BI. In the following sections we will answer the questions set in the previous paragraphs which should enable you to start using Python and looking to incorporate it into your data story needs. (more…)

By brandon, ago