Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Power BI visualize in Jupyter Notebook

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!

5 Replies

  • Zeinab's avatar
    Zeinab
    New Member
    3 years ago

    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.

  • Zeinab's avatar
    Zeinab
    New Member
    3 years ago

    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 ?

  • ahanfouf's avatar
    ahanfouf
    Frequent Visitor
    3 years ago

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

     

    Anybody found a solution ? 

     

  • Daniel_PBI's avatar
    Daniel_PBI
    Frequent Visitor
    3 years ago

    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. 👍