web
You’re offline. This is a read only version of the page.
close
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.