Comments
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.
How can a product be considered "enterprise" if the personal version does more?
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.
Is it really a need, I don't know why MS takes toooo much time to hear us.
Enterprise gateway support for Python scripting is MUST HAVE (considering PowerBI as a TOOL not just a TOY)
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.
Definitely it's an important add-on to the product.
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.
discovered this limitation and all other work arounds require much more work
This is a very wanted and needed feature that will unblock a lot of value for our customers.