Skip to main content
Microsoft Idea

Power BI

Declined

Python on Scheduled Refresh

Vote (159) Share
Ricardo Moreno's profile image

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)
Ricardo Moreno's profile image Profile Picture

Steve Scott on 06 Jul 2020 00:15:30

RE: Python on Scheduled Refresh

I need to be able to run python scripts. Not visualizations: data manipulation. It is absurd that I have to manually update every morning.

Ricardo Moreno's profile image Profile Picture

Power BI User on 06 Jul 2020 00:13:31

RE: Python on Scheduled Refresh

I wonder why it isn't possible because when I'm manually refreshing the report it works but scheduled refresh doesn't

Ricardo Moreno's profile image Profile Picture

Bruno Illipronti on 06 Jul 2020 00:12:23

RE: Python on Scheduled Refresh

I just faced the same problem. I have a Python step in Power Query... pretty simple pandas command and I am not allowed to schedule a refresh because of that

Ricardo Moreno's profile image Profile Picture

Power BI User on 06 Jul 2020 00:11:49

RE: Python on Scheduled Refresh

Please complete this

Ricardo Moreno's profile image Profile Picture

Youssef Youssef on 06 Jul 2020 00:11:31

RE: Python on Scheduled Refresh

Also we cannot vote for this idea as long as it is marked as completed!

Ricardo Moreno's profile image Profile Picture

Youssef Youssef on 06 Jul 2020 00:11:30

RE: Python on Scheduled Refresh

Dear ADMIN, this is not completed yet. You can only refresh data sets that use R/Python transformations using personal gateway not enterprise gateway.

Ricardo Moreno's profile image Profile Picture

Power BI User on 06 Jul 2020 00:11:27

RE: Python on Scheduled Refresh

Such a poor response from Microsoft. Really disappointing to not even know if or when they can look at getting this done.

Ricardo Moreno's profile image Profile Picture

Power BI User on 06 Jul 2020 00:11:15

RE: Python on Scheduled Refresh

'+1 that this is NOT completed!

Ricardo Moreno's profile image Profile Picture

Power BI User on 06 Jul 2020 00:08:24

RE: Python on Scheduled Refresh

'+1..... why was this marked as completed when the function doesn't exist?

Ricardo Moreno's profile image Profile Picture

Richard Power BI User on 06 Jul 2020 00:05:48

RE: Python on Scheduled Refresh

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.