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 (143)
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)
RE: Provide enterprise gateway support for power bi python scripting
This is a must! Someone processes could be enabled if this was available. I would love to see this move forward and a timeline related to its release.
RE: Provide enterprise gateway support for power bi python scripting
Definitely it's an important add-on to the product.
RE: Provide enterprise gateway support for power bi python scripting
Very much a necessary to enable on prem gateway. Ridiculous that on prem gateway cannot do everything personal gateway can do. This feature will enable much more flexibility in wrangling and working with data, which is crucial to power bi.
RE: Provide enterprise gateway support for power bi python scripting
discovered this limitation and all other work arounds require much more work