POWER BI REPORT IN JUPYTER NOTEBOOK

POWER BI REPORT IN JUPYTER NOTEBOOK

With the new powerbiclient Python package, you can now embed Power BI reports in Jupyter notebook. You can filter the report and use bookmarks to apply a saved view.

Lets go through the steps:

  1. Install the powerbiclient Python package using pip

2. In Jupyter notebook, import the Report class and models from the powerbiclient package.

3. Authenticate to Power BI using Azure AD, this will generate a code to authenticate with.

4. Get the Workspace/GroupID and Report ID from Power BI Service for the report you want to embed and add the IDs to the notebook.

5. Create an instance of Power BI report and embed the report to the output cell.

Note: If you see a blank output, refresh the browser.

To authenticate to Power BI using Embed token, use the following:

report = Report
(
group_id=group_id,
report_id=report_id,
access_token=access_token,
token_type=models.TokenType.Embed.value
)

Check here for details:

https://powerbi.microsoft.com/en-us/blog/announcing-power-bi-in-jupyter-notebooks/

Happy Embedding 🙂

2 thoughts on “POWER BI REPORT IN JUPYTER NOTEBOOK

  1. Great! was getting blank screen but after browser refresh its loading now. Thank you.

Comments are closed.

Comments are closed.