Forum Discussion

WOLFIE's avatar
WOLFIE
Helper I
2 years ago
Solved

Cannot plot the Plotly visual using Python in PBI desktop

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()

3 Replies