Python script as a data source in Power BI Service

[chulpanvl]

Hello!

I have created a dashboard which uses a Python script a s a data source (it makes requests to google analytics API). Python script works fine at PBI Desktop.

As far as I understood in order to refresh data in Power Bi Service on a regular basis I need to configure a On-premises data gateway (personal mode). I did that using this instructions https://docs.microsoft.com/en-us/data-integration/gateway/service-gateway-install

So first I installed and configured a standard gateway (named powerbi_python) and then a personal mode gateway. They are installed on the same machine as my pbix file and Python.

I am confused what should I do next. I want to add a new data source under this gateway but Python script isn’t on the list:

I go to settings -> datasets and there is a message saying the gateway isn’t configured correctly and an error message Extension{"extensionDataSourceKind":"Python","extensionDataSourcePath":"Python»} unable to add to gateway. Lower is another info saying the personal gateway is not installed although I did install it. Sorry the screen is in Russian.

What am I missing here?

[lbendlin]

Use a personal gateway in Power BI - Power BI | Microsoft Learn

[frustrated_user]

Hi, were you able to add the python extension in PowerBi service? I am facing the same issue.

[lbendlin · Accepted solution]

Remove both gateways and then reinstall the personal gateway.  Python scripts only work with personal gateways.

[Anonymous]

Hi , 

I have the same issue and already have an enterprise gateway install to talk to the server. Could I install an additional personal gateway for python to work ?

would having both cause an issue ? Pleas help 

[lbendlin]

You cannot use an Enterprise Gateway to run Python scripts.  Only works with Personal Gateways.

[Anonymous]

yes , but that is my problem, I need to refresh data from a server that needs an enterprise gateway ...

what should I do in this case ?

[lbendlin]

I need to refresh data from a server that needs an enterprise gateway

What do you mean ?  Do you not see that server from your work PC?

[Anonymous]

Well I am trying to publish an app and this requires scheduled refreshes at regular intervals and that is why we have the enterprise gateway installed.

Sorry I am new and if I am not making sense ... All I care about it that the app should be able to connect to a server extract data and the python code and update the visuals..

could both of this be done by personal gateway ?

[lbendlin]

yes.  The caveat is that the Personal Gateway app needs to be running and the PC it is running on needs to be switched on, at least for the times specified in the schedule.

[Anonymous]

Hi   @lbendlin  I tried using the personal gateway here and am encountering the below message for python :

Failed to update data source credentials: ADO.NET: Python script error. Traceback (most recent call last): File "PythonScriptWrapper.PY", line 2, in <module> import os, pandas, matplotlib File "C:\Users\VISNN\Anaconda3\lib\site-packages\matplotlib\__init__.py", line 207, in <module> _check_versions() File "C:\Users\VISNN\Anaconda3\lib\site-packages\matplotlib\__init__.py", line 192, in _check_versions from . import ft2font ImportError: DLL load failed while importing ft2font: The specified module could not be found. 

[lbendlin]

ok, what happened after you installed the ft2font module?

[Anonymous]

This is apparently to do with a version of matplotlib (https://stackoverflow.com/questions/24251102/from-matplotlib-import-ft2font-importerror-dll-load-fai...).. I uninstalled and upgraded the version of the package again but still I am facing the same issue .. I now have a personal gateway   but i keep getting the same error:

[MaramTariq0]

Hi, I'm facing the same issue. Is there a solution for that?

[Anonymous]

No Unfortunately not.. I stopped using python scripts in power BI.