Forum Discussion

chulpanvl's avatar
chulpanvl
Icon for Helper I rankHelper I
4 years ago
Solved

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

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

    • Anonymous's avatar
      Anonymous
      Not 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's avatar
        lbendlin
        Icon for Super User rankSuper User

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

  • frustrated_user's avatar
    frustrated_user
    Icon for Microsoft Employee rankMicrosoft Employee

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