Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Anonymous
Not applicable

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. However, these are all static charts and I would like to use some interactive features using Plotly Module. When I use plotly, there always shows an error of "no image created".

 

I know there is solutions in R to use Plotly but is there a solution to use Plotly with Python in Power BI?

 

Thank you.

1 ACCEPTED SOLUTION
v-piga-msft
Resident Rockstar
Resident Rockstar

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

 

Community Support Team _ Cherry Gao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

16 REPLIES 16
_robind
New Member

Hi @v-piga-msft, although not ideal, a static plotly image would be ok for now, but this requires fig.write_image('test.png') which requires kaleido.  What are the chances of having kaleido added to the list of approved libraries, so that users can at least view advanced plotly graphs that are not available in matplotlib or seaborn, like their go sankey plot...?

stevedep
Memorable Member
Memorable Member

Hi,

 

You could take a look at this blog post. It describes how to add an interactive Plotly Chart in Power BI. Its quite easy when you follow these steps. 

 

Kind regards, 

 

Steve. 

Anonymous
Not applicable

@Steve, the link can be opened, can you please check if the link is still valid?

Thanks,

Cherie

Hi,

The link is working for me, but I also added it on the blog over here.

Kind regards, Steve

Anonymous
Not applicable

Hi @stevedep ,

 

Thanks a lot. the artical does help, and i am following.

 

Regards,

Cherie

guilhermesilva
Regular Visitor

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
Not applicable

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

HamidBee
Impactful Individual
Impactful Individual

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.

I believe that this was always the case and that Plotly is still not integrated in Power BI via Python. Meaning, it still won't show graphs in Power BI. I still can't understand why Plotly works with R and not Python. To the Power BI team at Microsoft, please fix this.

ramzibenamara
New Member

Hi any updates on how to use plotly with Python script in Power BI, I can use it but the visualization come into a browser not into the power bi dashboard.

Any luck on plotly and Power BI?

Nop the only way is to do it In R not in python 

Just so that I understand correctly. Plotly in Python only works with R?

plotly in Power BI only works with R

That is really dissapointing news.

v-piga-msft
Resident Rockstar
Resident Rockstar

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

 

Community Support Team _ Cherry Gao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.