Microsoft Releases Power BI In Jupyter Notebooks

Microsoft has released Power BI in Jupyter notebooks. “You can now tell compelling data stories with Power BI in Jupyter notebooks,” according to the company.

With the new package,  you can embed Power BI reports, dashboards, dashboard tiles, report visuals or Q&A in Jupyter notebooks easily. Additionally, you can export data from visuals in a Power BI report to the Jupyter notebook for in-depth data exploration. You can also filter the report for quick analysis or use bookmarks to apply a saved view.

Power BI is a collection of software services, apps, and connectors that work together to turn your unrelated sources of data into coherent, visually immersive, and interactive insights. Your data may be an Excel spreadsheet, or a collection of cloud-based and on-premises hybrid data warehouses. Power BI lets you easily connect to your data sources, visualise and discover what’s important, and share.


Sign up for your weekly dose of what's up in emerging technology.

It consists of several elements that all work together, starting with a Windows desktop application called Power BI Desktop, an online SaaS (Software as a Service) service called the Power BI service and Power BI mobile apps for Windows, iOS, and Android devices. It is meant to bridge the gap between data and decision making. In March 2016, Microsoft released an additional service called Power BI Embedded on its Azure cloud platform. 

Project Jupyter exists to develop open-source software, open-standards, and services for interactive computing across dozens of programming languages.

Download our Mobile App

With the new package, you can install the Power BI Client for Jupyter from PyPI and find the open-sourced Python package and associate TypeScript widget on GitHub.

Here is a demo of the Power BI client for Jupyter notebooks as well.

And, here is an example of how to use the package in your application.

“You can also authenticate against Power BI using an embed token. To do this, pass the embed token and set the token type to Embed when creating the Power BI report instance,” said the blog post.

For instructions on how to run the demo, one can also check out the demo notebook section in the README file.The package documentation can be found in the GitHub repository wiki.

Additionally, here is a 3-step quick start guide for embedding Power BI in Jupyter notebooks. 

Support independent technology journalism

Get exclusive, premium content, ads-free experience & more

Rs. 299/month

Subscribe now for a 7-day free trial

More Great AIM Stories

Shanthi S
Shanthi has been a feature writer for over a decade and has worked in several print and digital media companies. She specialises in writing company profiles, interviews and trends. Through her articles for the Analytics India Magazine, she aims to humanise tech in India. She is also a mom and her favourite pastime is playing a game of monopoly or watching Gilmore Girls with her daughter.

AIM Upcoming Events

Early Bird Passes expire on 3rd Feb

Conference, in-person (Bangalore)
Rising 2023 | Women in Tech Conference
16-17th Mar, 2023

Conference, in-person (Bangalore)
Data Engineering Summit (DES) 2023
27-28th Apr, 2023

3 Ways to Join our Community

Telegram group

Discover special offers, top stories, upcoming events, and more.

Discord Server

Stay Connected with a larger ecosystem of data science and ML Professionals

Subscribe to our Daily newsletter

Get our daily awesome stories & videos in your inbox