Error gateway python in power bi service

[henryco88]

Hi,

I saved a python script in power bi desktop which reads a table from sql server and creates a pandas dataframe. Everything works correctly. When I publish the report on power bi service, I have an error with the python gateway and therefore I don't see the data:

Extension {"extensionDataSourceKind": "Python", "extensionDataSourcePath": "Python"}

I installed "On-premises data gateway (personal mode)" in my pc but I still see the error in power bi service. 

How can I solve it?

[vito123]

Hi Guys, 

I have the exact same issue now . My question is I already have an enterprise gateway installed and if i install personal gateway for the python to work will I have issues ?

Please help!!

[Fanz]

Hi I'm having a similar issue as well, did you find a solution?

[v-shex-msft · Accepted solution]

Hi @henryco88,

AFAIK, the current python script data source only works on gateway personal mode, you cant manage it in the on-premise gateway. 

If you want to enable the refresh on the power bi service side, you need to configure all the data sources used in your report.
I'd like to suggest you switch to a personal gateway if other types of data source supported in this gateway.(live mode data sources do not work on personal mode)

Use personal gateways in Power BI 

Regards,

Xiaoxin Sheng

[Zorg]

I have the same issue and have the on-premises data gateway (Personal mode).

Any idea why this might be the case???

[GilbertQ]

Hi there

Can you confirm that the version of Python that you are using is supported by the Power BI Gateway?

Here are more details to check: https://powerbi.microsoft.com/en-us/blog/python-visualizations-in-power-bi-service/#:~:text=Python%2....

https://sqlitybi.com/how-to-auto-schedule-data-export-from-power-with-pythn/