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 (147)
RE: Provide enterprise gateway support for power bi python scripting
Please help with this
RE: Provide enterprise gateway support for power bi python scripting
Any updates? After so many years still only Personal Mode of Data Gateway can be used?
RE: Provide enterprise gateway support for power bi python scripting
I'm using PowerBI in the company due to institutional policy.I have experience with Plotly-Dash and it does much more than PowerBI can imagine... When I saw the possibility of using Python in PowerBI, I adjusted several data with PowerQuery, consumed data and when publishing and updating, I discovered that the Gateway On Premisse does not update!!!This is not impressive! Reminds me of why I delved into open source products years ago...
RE: Provide enterprise gateway support for power bi python scripting
I am really disappointed to see this not supported. It's a feature that would allow us to use Python to directly query APIs and retrieve data.
RE: Provide enterprise gateway support for power bi python scripting
This is a need for more advanced analytics.
RE: Provide enterprise gateway support for power bi python scripting
Microsoft needs to add this feature to its roadmap! If enterprise gateways began supporting Python scripting then I could drastically improve the performance of my organization's Power BI Apps, dashboards, and datasets. Some of my organization's master datasets take far too long to refresh and use up valuable CPU resources, but if I could incorporate state-of-the-art Python libraries such as NumPy and Pandas then Power BI would allow vectorized data transformations and drastically improve dataset refresh runtimes and Workspace App page load times.
RE: Provide enterprise gateway support for power bi python scripting
How can a product be considered "enterprise" if the personal version does more?
RE: Provide enterprise gateway support for power bi python scripting
In my humble opinion, give this kind of support inside Python might be something hard to develop, because it involves the architecture. But the solution might be simple, if considering another perspective, that would also solve other kind of issues. Consider a query on Power Query Editor interface can use another query DATA when configuring the SOURCE, in a way I can CASCADE queries using their data to build other queries... Now Python support doesn't need any change. You could have a first query to bring the RAW data, then you run Python to transform that Data and generate a DataFrame, then you have another query that can refer to data on that first query, like as you would adding parameters dynamically to a SQL Server Query, that might also execute some Script, and so on.The power would be unlimited... Consider for example, during the first query, your python script generates as DataFrame the sql server query, that your second query should execute. Now your second query, on advanced parameters, where you can write the sql server query, could refer to that query on the DataFrame from previous query, and just execute it with the DataSource configured in the way you need.-- Today, to solve my problems, I run external jobs with Python, to generate that data on tables, so Power BI can ingest that data already processed. And it involves the purchase of COMPUTE resources to execute it. The QUERY CASCADE should solve many GAPs.
RE: Provide enterprise gateway support for power bi python scripting
Is it really a need, I don't know why MS takes toooo much time to hear us.
RE: Provide enterprise gateway support for power bi python scripting
Enterprise gateway support for Python scripting is MUST HAVE (considering PowerBI as a TOOL not just a TOY)