Forum Discussion
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...
Do you have a gateway installed and is Python installed on the gateway?
Use Python in Power Query Editor (it mentions the use of Gateway)
https://docs.microsoft.com/en-us/power-bi/connect-data/desktop-python-in-query-editor
Use personal gateways in Power BI (it teaches how to install Gateway)
https://docs.microsoft.com/en-us/power-bi/connect-data/service-gateway-personal-mode