Personal Data Gateway Refresh Python

[Anonymous]

Hello,

I have a report with python data source and am unable to schedule a refresh with the personal data gateway. I get the following error: 

You can't schedule refresh for this dataset because the following data sources currently don't support refresh:
Data source for data_frame
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.

I have the personal gateway app installed and the diagnostics test do show successful connections. The report works fine in Desktop. Is there some other configuration I need to do?

[michaelx2]

Hello thepete1,

Did you try to run the python script via python console on the gateway? Add is the detected python home directories consistent with the path setting in environment variables?

Best Regards,

Michael

[Anonymous]

Yea the gateway is in personal mode on the same machine that it was developed on. Script works fine running directly on the machine. Is there something specifically to try through the gateway app?

[michaelx2]

Is there only one version of python installed on your gateway?If there are different versions installed , please make sure the libraries used in your script could be imported correctly with the detected python home directory in python script options.

[Anonymous]

Yep only 1. I started with 3.8 but removed that and put 3.7.1 since that is what the documentaion references. Is there a specific version that should be used?

[michaelx2]

Hello thepete1,

There is no specific version of python for that. I'm using version 3.8, and it works. How did you get the data in your script, is there some external data in your script? If possible, please provide the script code snippet.

Best Regards,

Michael

[Anonymous]

Sorry was on vacation so late getting back to this! Yes the script does get external data via an API call which is why I am trying to use the personal gateway. I did test the sample python script from here https://docs.microsoft.com/en-us/power-bi/desktop-python-scripts and i get the exact same error

[Greg_Deckler]

Install Python on your gateway?

[Anonymous]

I've got it install on the same machine as the gateway. Is there something specifically to add it to the gateway?