Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Query contains unknown function name: Python.Execute

I used a Python script in Power Query to pull data from a Google Sheet. It works fine in PBI Desktop, but I get an error for the automated refresh: You can't schedule refresh for this dataset becau...
Need Help
  • Greg_Deckler's avatar
    Greg_Deckler
    6 years ago

    Do you have a gateway installed and is Python installed on the gateway?

Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
6 years ago

Do you have a gateway installed and is Python installed on the gateway?

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    I did not, had not realized that was necessary, but I now installed it and it worked!

    • Greg_Deckler's avatar
      Greg_Deckler
      Icon for Community Champion rankCommunity Champion
      6 years ago
      Great! 🙂
    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago
      How can I install Python on the gateway?Thanks!
    • purpleme_fin's avatar
      purpleme_fin
      Frequent Visitor
      5 years ago

      how did you do that. Thanks in advance

  • rameshmadhubhas's avatar
    rameshmadhubhas
    Frequent Visitor
    3 years ago

    Hi Greg_Deckler,
    I got the same type of Issue:

    How can I sort this issue without using an On-premises data gateway?
    Can I use the VNet data gateway to address this issue?