Forum Discussion

lionx's avatar
lionx
Helper I
3 years ago
Solved

How to Install & configure Python for the On-premises data gateway?

I try to schedule refresh data for Python script data source in Power BI service but I get the error "Query contains unknown function name: Python.Execute". 

You can't schedule refresh for this dataset because the following data sources currently don't support refresh:

Discover Data Sources
Query contains unknown function name: Python.Execute Unknown function name: Python.Execute is a valid Mashup library function name format. Hence fail the operation.

The Python script works well in Power BI Desktop but not for schedule refresh data in Power BI service. I find the solution in the following link that is to install Python in data gateway:

Solved: Re: Query contains unknown function name: Python.E... - Microsoft Power BI Community

I did install the On-premises data gateway but I don't know how can I install Python on the gateway. 

 

 

 

 

 

 

 

 

 

Dataflow
Need Help
  • v-yueyunzh-msft's avatar
    v-yueyunzh-msft
    3 years ago

    Hi , lionx 

    Are you trying to use an enterprise gateway? That won't work.  Python and R scripts require a personal gateway. That personal gateway will automatically share the libraries that you have installed on that PC.

     

    For more information, you can refer to :

    Power BI Gateway | Microsoft Power BI

    Use personal gateways in Power BI - Power BI | Microsoft Learn

     

    Thank you for your time and sharing, and thank you for your support and understanding of PowerBI! 

     

    Best Regards,

    Aniya Zhang

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

8 Replies

  • v-yueyunzh-msft's avatar
    v-yueyunzh-msft
    Community Support
    3 years ago

    Hi , lionx 

    Are you trying to use an enterprise gateway? That won't work.  Python and R scripts require a personal gateway. That personal gateway will automatically share the libraries that you have installed on that PC.

     

    For more information, you can refer to :

    Power BI Gateway | Microsoft Power BI

    Use personal gateways in Power BI - Power BI | Microsoft Learn

     

    Thank you for your time and sharing, and thank you for your support and understanding of PowerBI! 

     

    Best Regards,

    Aniya Zhang

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

      • v-yueyunzh-msft's avatar
        v-yueyunzh-msft
        Community Support
        3 years ago

        Hi , lionx 

        Oh ... I go to the Power BI Support web site and see the konwn issue!

        Support | Microsoft Power BI

        For this problem, the official website has been released, you can wait patiently to fix it!

         

        Thank you for your time and sharing, and thank you for your support and understanding of PowerBI! 

         

        Best Regards,

        Aniya Zhang

        If this post helps, then please consider Accept it as the solution to help the other members find it more quickly