Skip to main content
Microsoft Idea

    Power BI

    Under Review

    Provide enterprise gateway support for power bi python scripting

    Vote (1391) Share
    Tom's profile image

    Tom on 24 May 2019 02:18:36

    Provide enterprise gateway support for python scripting - currently only personal gateways are supported

    Administrator on 01 Apr 2024 05:48:32

    Fabric will have better support for this and will be a better choice

    Comments (141)
    Tom's profile image Profile Picture

    Power BI Ideas Admin on 06 Jul 2020 00:04:33

    RE: Provide enterprise gateway support for power bi python scripting

    I've run into a need for Python support in a couple of reports. Running a personal gateway is not a viable option in our environment, so it would be very helpful if Microsoft could add this to the roadmap.

    Tom's profile image Profile Picture

    Jeffrey Arant on 06 Jul 2020 00:04:14

    RE: Provide enterprise gateway support for power bi python scripting

    In our organization, using Python is normally the best solution for programatically renaming columns and shaping data - especially when pulling data from Azure Cosmos DB (or anything that is JSON based).

    Tom's profile image Profile Picture

    Richard Power BI User on 06 Jul 2020 00:04:08

    RE: Provide enterprise gateway support for power bi python scripting

    It’s definitely nice that there is support for Pandas and even the visualisation libraries (ditto R), but as others have mentioned it would be fantastic if it were possible to schedule regular refreshes for the company as a whole.

    Then Power BI would truly be the one-stop shop for analytics and data science that it is clearly aiming to be.

    Tom's profile image Profile Picture

    Anderson Oliveira on 06 Jul 2020 00:03:20

    RE: Provide enterprise gateway support for power bi python scripting

    Python today is one of the largest programming languages, everyone needs updating via Gateway.
    I hope Microsoft is aware of how important it is that these timing work !!!
    Thanks to the whole community for adjusting this issue !!!

    Tom's profile image Profile Picture

    Enrico on 06 Jul 2020 00:03:13

    RE: Provide enterprise gateway support for power bi python scripting

    Please provide enterprise gateway support for Power BI python scripting to allow data refresh processes

    Tom's profile image Profile Picture

    Raksha on 06 Jul 2020 00:03:06

    RE: Provide enterprise gateway support for power bi python scripting

    Please provide schedule refresh process for python scripting in enterprise gateway.

    Tom's profile image Profile Picture

    Power BI Ideas Admin on 06 Jul 2020 00:01:21

    RE: Provide enterprise gateway support for power bi python scripting

    Seems like its not really a proper feature if you can't refresh it properly for your company, so I think this should definitely be added (good to have it for R as well)

    Tom's profile image Profile Picture

    George Power BI User on 06 Jul 2020 00:01:14

    RE: Provide enterprise gateway support for power bi python scripting

    I'm surprised this doesn't have more votes. Why even have the Python script button in the Power Query editor if it can't be scheduled for a refresh in the gateway? Python has much greater adoption when compared to M.

    Tom's profile image Profile Picture

    kachalio on 05 Jul 2020 23:58:47

    RE: Provide enterprise gateway support for power bi python scripting

    Python data sources allow me to query APIs directly. It would be great to be able to schedule refreshes for API data sources

    Tom's profile image Profile Picture

    dan on 05 Jul 2020 23:51:21

    RE: Provide enterprise gateway support for power bi python scripting

    I strongly support this idea- I find pandas data munging capability far more succinct and intuitive to use than M and DAX so if I was able to leverage python in reports that auto refresh via our enterprise gateway I would be able to develop much better reports and consequently be more effective in demonstrating the value of power bi to my organisation..