Microsoft has also supplied a demo Power BI file with working examples of popular Python packages used to create visualizations and transformations for a sample data set.

Power BI quick measures can return a simple running total and a year-to-date total with little effort on your part.

Microsoft is considering adding Python as one of the official Excel scripting languages, according to a topic on Excel's feedback hub opened last month.