Ricardo Moreno on 25 Aug 2018 03:30:02
On PowerBi Desktop we can get data using Python Scripts, but after published we can't schedule a refresh data for this connection. The PowerBI returns:
"Query contains unknown funtion name: Python.Execute."
It would be better if all features on desktop would work on web too.
Administrator on 11 Sep 2020 22:16:26
Please see the gateway section here: https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/20285920-python-script-in-power-bi
- Comments (49)
RE: Python on Scheduled Refresh
Please reopen this idea. It is not a feature.
RE: Python on Scheduled Refresh
This is not complete. Please reopen
RE: Python on Scheduled Refresh
This feature is NOT complete. Please enable Python scripts to have schedule refresh on an On Premise gateway.
RE: Python on Scheduled Refresh
'Power BI Data Gateway in Enterprise mode don’t support refresh of Python script dataset in power BI service.
Once you've uploaded the .pbix file (Developed reports from python script) to the Power BI service, a couple more steps are necessary to enable data refresh (in the service) The additional steps are the following:
- Enable scheduled refresh for the dataset – Need to enable scheduled refresh for the dataset with Python scripts
- Install the Personal Gateway - you need a Personal Gateway installed on the machine where the file is located, and where Python is installed.
Limitations regarding refresh of python script in Power BI.
To enable scheduled refresh of your Python visuals or dataset, you need to enable Scheduled refresh and have a Personal Gateway installed on the computer that houses the file and the Python installation.
We apologize for the inconvenience caused due to the product limitation or product not working as per your expectation. I totally agree with you and all of your concerns and they are completely valid.
Our Product team pushes improvements and features on weekly basis. These improvements are planned well in advance. But there are some of the improvements which will have lot of dependencies due to which it takes long time and sometimes it becomes extremely hard for us to define an ETA even though we have a road map of improving the feature. We hope you understand the complexity here. Our focus is always on improving customer experience and giving what customer is looking for sooner or later.
We would encourage you to see if this idea already exists. If not please post this awesome idea @ Power BI Ideas and vote for it.
Based on you confirmation I am closing the case from our end. If you have any feedback or concerns about your case, please feel free to contact me. All that is required is an email to me.
Appreciate your support and partnership with Microsoft. You are our valuable customer and we strive to ass
RE: Python on Scheduled Refresh
this feature is not available,
why is it marked as completed ?
RE: Python on Scheduled Refresh
Please don't mark this as completed. Not supported by Power BI service. Please make it available as soon as possible.
RE: Python on Scheduled Refresh
No available for enterprise gateway, please continue working on it.
RE: Python on Scheduled Refresh
This function is still not available. I don't understand why admin marked it completed above.
RE: Python on Scheduled Refresh
Is the ability to do a scheduled refresh for a python script in the pipeline? On the ideas forum it's marked as completed - but refreshing the data inside the web application does not work.
RE: Python on Scheduled Refresh
This function should be added ASAP. I wrote lots of Python code to analyze my data and then realized that I need to refresh it by hand everyday because schedule refresh for Python is not available.