Skip to main content

    Power BI

    Declined

    Python on Scheduled Refresh

    Vote (143) 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

    bfd09b49 fb76-4733-a17a-f3dc9a2d9bfa 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

    ccd6761a 3832-49bc-8dec-54bb4152e8c2 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

    c29a1822 f24b-4df9-a5f3-f42b8e41e579 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

    425134d4 57bc-4f16-89be-a5536f282f0b on 06 Jul 2020 00:11:49

    RE: Python on Scheduled Refresh

    Please complete this

    Ricardo Moreno's profile image Profile Picture

    92daa193 f0c8-4111-835c-a1b8d8655b47 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

    92daa193 f0c8-4111-835c-a1b8d8655b47 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

    0f8593bf a6ad-4e15-bc1a-2bee47fbf4a1 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

    9d795ecb 78b5-459a-b0cc-81f4ce6a54fc 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

    634e5cb7 f4db-437e-a241-f72c0aa93d12 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

    0ca176e9 328e-4ffb-9929-4fbd31ae424f 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.