Publish report with Python File data source

[volyn]

Hello,

I was asked by my colleague about option to publish report to POWER BI service, which data source is Python script. He used Python source script for loading SPSS files from folder. In that folder are each day new SPSS files, so he needs to schedule refresh at POWER BI service site.

Any idea how to do that please?

Thanks a lot

[AlexisOlson · Accepted solution]

For it to work in the service, you have to be able to connect to the data source somehow. Python scripts can still work in the service but the data has to either be stored in the cloud or else you'll have to set up a data gateway to read from your local source.

[v-chenwuz-msft · Accepted solution]

Hi @volyn ,

You need to install a personal gateway. Only personal gateway supports python script.

One more thing, for the Python scripts to work properly in the Power BI service, all data sources need to be set to public.

https://docs.microsoft.com/en-us/power-bi/connect-data/desktop-python-in-query-editor#using-python-i... 

Best Regards

Community Support Team _ chenwu zhu

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

[AlexisOlson · Accepted solution]

For it to work in the service, you have to be able to connect to the data source somehow. Python scripts can still work in the service but the data has to either be stored in the cloud or else you'll have to set up a data gateway to read from your local source.