Power BI in Jupyter Notebook Tutorial | powerbiclient Python Package

Now it is possible to embed a Power BI Report in your Jupyter Notebook, an easy and interactive way to show your dashboard in your notebook. In this video I'll explain how can you install and import the powerbiclient Python library, to then use it to connect with your account and display the report you need. Easy and fast !

This dashboard belongs to a complete Machine Laarning tutorial, check here the videos:

📚 GREAT BOOKS that I use for Python and Data Science
==============================================

Music credits:
Song: MBB - Feel Good (Vlog No Copyright Music)
Music provided by Vlog No Copyright Music.

#PowerBI #JupyterNotebook #Python #dataviz

[jennyhorvatinovic]

If you just want to access the dataset how do you do that? I have a query in power bi that I want to run analysis on with python. How can I import this power query dataset into a dataframe in jupyter notebook?

[Azkro]

I see that you need to set up a POWER BI CLIENT account, is this payment only?

[zafarpat]

how do we pass parameters to report from notebook?

[manuruiz]

Good contribution!!!. Do you know how to convert this report to pdf once you read it in jypyter?

[vithyait]

it runs fine
report.get_bookmarks()
it gives blank

also why the personal bookmark set in powerbi report not shown in code when i try to set the bookmark and get bookmark directly in code also not working.

could you please show an example

[vithyait]

report = Report(embed_url=embedUrl, auth=device_auth)
when i try to embed report this way by giving the URL directly report is not embedded it shows blank
when i give report comment

[vithyait]

After calling the report how to click on to page2 in report using command ...

[amrasfoor]

very nice tutorial, I applied all the steps and it worked good but the report does not appear at the end although my power bi account are pro

[Dmitriy-xqbr]

No module named 'powerbiclient'

how to solve it?

i did pip install powerbiclient

[suzaam]

Nice tutorial. What would be the use case for this?

[norpriest]

So this needs premium account only?
Pro account no?

[vithyait]

powerbiclient\report.py in export_visual_data(self, page_name, visual_name, rows, export_data_type)
443 error_message = self._client_error
444 self._client_error =
--> 445 raise Exception(error_message)
446
447 return exported_data

Exception: {"message":"ExportDataFailed", "detailedMessage":"Operation is allowed only on active page", "level":3, "technicalDetails":{}}


activepage, visuals all have data related to page2 and
If i click on page2 manually in report then it works otherwise report is still in page1 and i get the above errror .to fix this i need to move from page1 to page2 with code

i want to move from one page to another without clicking in embedded report manually.can you help in solving this issue

code i used


visual=next(filter(lambda visuals:visuals['name']== '8e6cf1', visuals))
visual_name=visual['name']
visual_name


Summarized_data=report.export_visual_data(active_page, visual_name, rows=51)