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.

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.

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. 

Download our Mobile App

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.

Subscribe to our newsletter

Join our editors every weekday evening as they steer you through the most significant news of the day.
Your newsletter subscriptions are subject to AIM Privacy Policy and Terms and Conditions.

Our Recent Stories

Our Upcoming Events

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

Can OpenAI Save SoftBank? 

After a tumultuous investment spree with significant losses, will SoftBank’s plans to invest in OpenAI and other AI companies provide the boost it needs?

Oracle’s Grand Multicloud Gamble

“Cloud Should be Open,” says Larry at Oracle CloudWorld 2023, Las Vegas, recollecting his discussions with Microsoft chief Satya Nadella last week.