Python run time error in Power BI

[HimakarM]

Hi,

I am facing a run time error while executing the python code mentioned below which creates a bar chart row facet visual.

Py code - 

import plotly.express as px

fig = px.bar(dataset,x = 'employee', y = 'salary', facet_row = 'job_title ', color = 'job_location')

fig.update_layout(legend_orientation = 'h', x=-1, y=1.2)

fig.show()

Error - Can't display the visual

scripts stop running after 5 minutes. To fix this, reduce your script's runtime and try again

Can anyone assist me to resolve this issue? 

It will be a great help if anyone comes forward with the solution and also wanted to know the reasons for encountering this issue in Power BI.

Thanks in advance!

[v-lili6-msft]

hi @HimakarM 

This is a known limitation:

Python visuals in Power BI Desktop have a few limitations:

• Data size limitations. Data used by the Python visual for plotting is limited to 150,000 rows. If more than 150,000 rows are selected, only the top 150,000 rows are used and a message is displayed on the image. Additionally, the input data has a limit of 250 MB.
• Resolution. All Python visuals are displayed at 72 DPI.
• Calculation time limitation. If a Python visual calculation exceeds five minutes the execution times out which results in an error.

https://docs.microsoft.com/en-us/power-bi/connect-data/desktop-python-visuals#known-limitations

Regards,

Lin

[HimakarM]

Thanks for the valuable information, Lin.

My script doesn't contain any calculations apart from the legend positioning. I am able to plot the visual by excluding this step mentioned below. 

fig.update_layout(legend_orientation = 'h',x=-1, y=1.2)

The above line is included in my script to plot a customized legend using the coordinates. Can you please shed more light on this run time error and the chances of encountering this problem?