Power BI visualize in Jupyter Notebook

[Anonymous]

I am trying to use PowerBI in Jupyter Notebook.

I want to create a PowerBI report using the (Financial sample.xlsx) dataframe in Jupyter NB. 

The following code is run:

from powerbiclient import QuickVisualize, get_dataset_config, Report
from powerbiclient.authentication import DeviceCodeLoginAuthentication

import pandas as pd

df = pd.read_excel("Financial sample.xlsx")

df.head()

device_auth = DeviceCodeLoginAuthentication()

## Device Authentication for Integration process was completed successfully

PBI_visualize = QuickVisualize(get_dataset_config(df), auth=device_auth)

PBI_visualize

.... After this last line is run, I get the following message ... 

Not sure what is going wrong!

[Daniel_PBI]

Same for me:
Authentication seems to work fine:

from powerbiclient.authentication import DeviceCodeLoginAuthentication
device_auth = DeviceCodeLoginAuthentication()

After running and authentication is done the following appears: 

Device flow authentication successfully completed. You are now logged in . The result should be passed only to trusted code in your notebook.

And after that:

PBI_visualize = QuickVisualize(get_dataset_config(df), auth=device_auth)
PBI_visualize

Results in neither an error nor a response.

Further input is highly appreciated. 👍

[ahanfouf]

I have the same strange behaviour, that nothing is shown... I tried both authentication methods and restarted the kernel. 

Anybody found a solution ? 

[Zeinab]

I use the same code and after this line 

PBI_visualize = QuickVisualize(get_dataset_config(df), auth=device_auth)

PBI_visualize

NO report is showen neither error, it runs with no return.

Anyone faces the same issue ?

[lbendlin]

Try using Interactive_auth instead.

[Zeinab]

Hi,

I think this error related to the authentication part, run the line of authentication separately then follow the steps till the authentication is succeded.