Python on PowerBI Service

[qanderson1992]

We are migrating our PowerBI dashboard to a server and using PowerBI Service as the primary platform.  The issue is that we are running into errors autorefreshing the data on powerBI Service because our dashboard uses python for a bit of data cleaning and a single visual.  The issue appears to be something to do with power bi connecting to python while updating.  Python is up to date on it's packages and pointing correctly and when run using PowerBI desktop everything works fine.  We have tried experimenting with permissions in the dashboard but this simply results in different errors.

When our permissions levels set to Organization we get the following error.

When our permissions levels are set to Public we get the following error.

What is causing the connection issue and how can we resolve it?  Can PowerBI service use the python connection?  If not why not?

[Anonymous]

Hi @qanderson1992 ,

The error message shows it timeout.

specify appropriate value in “Command timeout in minutes (optional)" following steps below, then check if you can  refresh successfully in Power BI Desktop.

1. Click on the arrow for "Edit Queries" in your current Power BI Desktop file, select "Data Source Settings” in the dropdown.
2. Click on "Change Source..." in the Data source settings pop-up window.
3. Click on Advanced Options in the pop-up window, enter 60 minutes in the "Command timeout in minutes (optional)" textbox, then click OK.

Best regards.
Community Support Team_ Caitlyn