How are python scripts executed when refreshing on the service?

[tomi5]

Hi,

I have a table in power bi that is imported into power bi, then I run a python script on this that performs sentiment analysis and adds a row to the table saying if the comment is positive, negative, or neutral.

To get this to work I have python installed on my local machine and all the relevant libraries for python that allow this to work.

When I go to publish this report to the service and set an automated refresh will it know how to execute the python script when it refreshes? I am just wondering how it can execute this in the service, does it see which libraries are dependencies for the script then install them on the service (along with installing python itself?) somehow?

Or am I completely not understanding how python scripts are executed on the service.

Thanks

[ibarrau]

Hi. I'm not sure if there are deep specifications about this, but let me share my thoughts on this. The main reason why python scripts must have an on premise data gateway installed with Personal Mode is the answer. You must set up the environment on the VM that contains the gateway. Installing python and the libraries there will help the engine run the PowerQuery M script containing Python (unless you have built the pbi desktop reports on the same machine of the gateway, then you already have everything) when the refresh is triggered at Service. 

I hope that make sense