Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

[help] sankey image can't be displayed in poweBI

Hi team, 

I have below script.

 

 

import pandas as pd
import chart_studio.plotly as py
import plotly.graph_objects as go
labelListTemp1 = list(set(dataset.source.values))
labelListTemp2 = list(set(dataset.target.values))
labelList = labelListTemp1 + labelListTemp2
sankey_node = list(dict.fromkeys(labelList))
fig = go.Figure(data=[go.Sankey( node = dict( pad=15, 
                                             thickness=20, 
                                             line = dict(color = "black", width = 0.5),
                                             label = labelList,
                                             color = "blue" ),
                                              link = dict(source = dataset.source.apply(lambda x: labelList.index(x)),
                                                          target = dataset.target.apply(lambda x: labelList.index(x)),
                                                          value = dataset.value))])

fig.show()

 

 

 

 And I run it in powerBI with enabling python script. but the result is that the code opened a browser and displayed the sankey in browser, instead of  in powerBI.

1. the code opened a browser and displayed the sankey in browser.

2. I would like the sankey chart displayed in powerBI, but powerBI says that  'the visual can't be displayed'.

 

 

Is there anyone that succesfully created sankey chart by python plotly lib?  can any expert help take a look what's wrong here?

 

Thanks,

Cherie

No Replies