Python on Scheduled Refresh
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.
Please see the gateway section here:
Not solved at all. Don't consider using Python scripts in Power BI as it is now, the number of libraries supported for scheduled refresh gives almost none of the Python features.
Johan A. Holm commented
In what way is this issue complete? The issue still persists, please reopen this.
Theo DSza commented
This issue is not solved, please reopen this idea. Please enable schedule refresh with python scripts on On premise gateway.
Having such a nice way to get data without being able to schedule refresh, is almost useless unfortunatly.
Troy Prill commented
Please reopen this idea. It is not a feature.
This is not complete. Please reopen
This feature is NOT complete. Please enable Python scripts to have schedule refresh on an On Premise gateway.
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 assist you better and better every day, thank you.
Engineer - Microsoft Business Intelligence
Time Zone: IST
Hours: 01:30 PM – 10:00 PM
this feature is not available,
why is it marked as completed ?
Please don't mark this as completed. Not supported by Power BI service. Please make it available as soon as possible.
No available for enterprise gateway, please continue working on it.
Viet Pm commented
This function is still not available. I don't understand why admin marked it completed above.
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.
Viet Pm commented
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.
Please add soon, thanks!
Adding python to PowerBI without allowing it to run on the web update defeats the purpose; if I have to run it manually, I'd just use a Jupyter Notebook... I use PowerBI to allow for daily updates and to share with my team in real-time.
Please allow python scripts to run on the web app as you have done with R.
Also, there needs to be a way to upload models made in sklearn [or other packages] to run on this, so that we can train our models offline and just run them on the updates.
Please include this feature asap.
Ram Sekhar Grandhi commented
Very much needed, please include it
Great initiative, please include it!!
Please! It would be really helpful