Forum Discussion
Python script as a data source in Power BI Service
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?
Remove both gateways and then reinstall the personal gateway. Python scripts only work with personal gateways.
14 Replies
- lbendlin
Super User
Remove both gateways and then reinstall the personal gateway. Python scripts only work with personal gateways.
- AnonymousNot applicable
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
Super User
You cannot use an Enterprise Gateway to run Python scripts. Only works with Personal Gateways.
- frustrated_user
Microsoft Employee
Hi, were you able to add the python extension in PowerBi service? I am facing the same issue.