topic Cannot plot the Plotly visual using Python in PBI desktop in Developer

Cannot plot the Plotly visual using Python in PBI desktop

WOLFIE — Thu, 04 Jul 2024 08:10:54 GMT

Hi,

Could you please advise how to resolve this error? My Python script works fine in Databrics, however, when I run it in Power BI it opens up the visual in the browser window instead and gives me this error:

Here is the code:

import pandas as pd import plotly.express as px # Create a DataFrame dataset = pd.DataFrame(dataset) # Convert 'End Date' and 'Start Date' to datetime objects dataset['End Date'] = pd.to_datetime(dataset['End Date']) dataset['Start Date'] = pd.to_datetime(dataset['Start Date']) # Calculate the difference in days between 'End Date' and 'Start Date' dataset['diff'] = (dataset['End Date'] - dataset['Start Date']).dt.days # Reverse the DataFrame to match the reversed y-axis labels dataset = dataset.iloc[::-1].reset_index(drop=True) # Create a figure and axis fig = px.timeline(dataset, x_start="Start Date", x_end="End Date", y="Event Description", color="Group Name", hover_data={"Start Date": "|%Y-%m-%d", "End Date": "|%Y-%m-%d"}, labels={"Start Date": "Start Date", "End Date": "End Date"}) # Update layout fig.update_layout( title='Timeline', xaxis=dict( title='Date', tickformat='%Y' ), yaxis=dict( title='Group Name' ) ) # Show the figure fig.show()

Re: Cannot plot the Plotly visual using Python in PBI desktop

lbendlin — Fri, 05 Jul 2024 00:38:52 GMT

You cannot bring your own renderer, you need to use the default renderer.

Create Power BI visuals using Python in Power BI Desktop - Power BI | Microsoft Learn

Re: Cannot plot the Plotly visual using Python in PBI desktop

WOLFIE — Fri, 05 Jul 2024 06:32:03 GMT

This is annoying as Plotly is the only option that provides interactive visual 😕 Thanks for your response.

Re: Cannot plot the Plotly visual using Python in PBI desktop

lbendlin — Fri, 05 Jul 2024 19:13:24 GMT

If this is important to you please consider voting for an existing idea or raising a new one at https://ideas.fabric.microsoft.com/?forum=2d80fd4a-16cb-4189-896b-e0dac5e08b41