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:
Agreed that this is not really useful until it's available via the enterprise gateway, unfortunately. Quite a few other BI tools already have this functionality.
I agree that this is no complete until it's supported in the enterprise gateway.
I'm throwing in with the comments below. This is not complete because Python sources are not supported in the enterprise gateway. Supporting this in the personal gateway is somewhat helpful but far from an enterprise solution. Please add support in the enterprise gateway.
xiao meng commented
keen to support the refresh function with python data sources please.
Completely agree to the comments below. Need to support the refresh function with python data sources.
May as well just refresh from Power BI desktop if it has to be installed on a computer where the file sits.....
Carlos Useche commented
This is not working, schedule refresh is not allowed for Python data sources yet.
Kale-ab Tessera commented
Please re-open this is critical.
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.