How can we improve Power BI?

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.

144 votes
Sign in
(thinking…)
Sign in with: facebook google
Signed in as (Sign out)

We’ll send you updates on this idea

Ricardo Moreno shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →

29 comments

Sign in
(thinking…)
Sign in with: facebook google
Signed in as (Sign out)
Submitting...
  • Anonymous commented  ·   ·  Flag as inappropriate

    This feature is NOT complete. Please enable Python scripts to have schedule refresh on an On Premise gateway.

  • Anonymous commented  ·   ·  Flag as inappropriate

    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.

    Regards,
    Madhu Tallapaneni
    Engineer - Microsoft Business Intelligence
    Time Zone: IST
    Hours: 01:30 PM – 10:00 PM
    Email: v-matall@microsoft.com

  • yotam commented  ·   ·  Flag as inappropriate

    this feature is not available,
    why is it marked as completed ?

  • Anonymous commented  ·   ·  Flag as inappropriate

    Please don't mark this as completed. Not supported by Power BI service. Please make it available as soon as possible.

  • Viet Pm commented  ·   ·  Flag as inappropriate

    This function is still not available. I don't understand why admin marked it completed above.

  • Anonymous commented  ·   ·  Flag as inappropriate

    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  ·   ·  Flag as inappropriate

    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.

  • Darin commented  ·   ·  Flag as inappropriate

    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.

  • Rob Charlton commented  ·   ·  Flag as inappropriate

    Ditto to the other comments. If python features can't be used in the webservice, it's much more limited in its usefulness.

  • Anonymous commented  ·   ·  Flag as inappropriate

    Yes! This is very much needed if the python feature will be of use to our company.

← Previous 1

Feedback and Knowledge Base

Ready to get started?

Try new features of Power BI today by signing up and learn more about our powerful suite of apps.