Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Use Plotly with Python Script in Power BI

Hello,   I'm a deep python user so would like to use it in Power BI. I have tried matplotlib and seaborn library - there are no error to use them as long as I put "plt.show()" in the scripts. Howev...
Need Help
  • v-piga-msft's avatar
    v-piga-msft
    7 years ago

    Hi Anonymous ,

    I'm afraid that Plotly is not supported in Power BI currenly.

    Based on the blog, only the following Python packages (non-Intel MKL) are currently supported for use in your Power BI reports.

    • matplotlib
    • numpy
    • pandas
    • scikit-learn
    • scipy
    • seaborn
    • statsmodels

    In addition, you could refer to this similar thread which should make sense.

    Best Regards,

    Cherry

     

guilhermesilva's avatar
guilhermesilva
Regular Visitor
4 years ago

I am able now to make a plotly graph inside Power BI using python.
However, Power BI shows my graph in a new window of my browser (instead of showing into the Power BI framework).

The last line of my code is

fig.show()

How could I print it into the Power BI framework? 

Anonymous's avatar
Anonymous
Not applicable
4 years ago

use fig.write_image('test.png'). but it's a static image, can't be interactive.

  • HamidBee's avatar
    HamidBee
    Power Participant
    4 years ago

    I am using this example sample code:

     

    import plotly.express as px
    data_canada = px.data.gapminder().query("country == 'Canada'")
    fig = px.bar(data_canada, x='year', y='pop')
    fig.write_image('test.png')
     
    however it doesn't seem to work. When I use fig.show() it will show the chart but in a web browser.