The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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