Enterprise Gateway Not Configured Correctly only with Python in report

[ngoodweiler]

Hello everyone. I have a problem with accessing an enterprise gateway on a new report I developed. In the screenshot you can see that it says the entire gateway status is "Not configured correctly" but this only happens on the newest report I have that has Python scripts in the queries. The gateway is online, MANY other reports are using the same intranet connection that is in the screenshot and working just fine, this only happens on the report with Python.

I installed a personal gateway on my own computer to have Python work through it for now. Do I need to have the personal gateway installed on the same machine as the enterprise? My plan was to use the enterprise gateway for the SQL connections, cloud connections for things like sharepoint and Salesforce (the web and Salesforce connections in screenshot and these work fine), and a personal gateway for Python. Is this not possible? It would take a long time and I dont know if it is even possible to use Power Query and DAX to replace the Python scripts in the report, so I would much rather be able to use a personal gateway along with an enterprise depending on the connections.

As a note I am not an admin for the gateway or connections. Is there maybe a setting in the gateway that needs to be changed to allow users to use personal gateways in conjunction with the enterprise?

Another option I thought of was to not use the enterprise gateway at all and install a personal mode gateway on a server we have, but that defeats the purpose of having a managed enterprise gateway doesnt it?

I guess overall my question boils down to how can I use Python in a report that uses an enterprise gateway for all of its data source connections?

[Anonymous · Accepted solution]

Hi,@ngoodweiler.I am glad to help you.
I'm very happy to see that you yourself have temporarily solved the problem of failed gateway connections by connecting through a personal gateway. Using a personal gateway is indeed a viable approach for data sources containing python scripts that are not supported by On-premise gateway. However, as you feared, this may not be appropriate.
Your idea is feasible, but you need to be careful about using a combination of enterprise and personal gateways, permissions and settings need to be configured correctly for this to work.
I would prefer to use the official recommendation, which is that Microsoft recommends Fabric Notebooks instead of the Personal Gateway for connecting to data sources that contain python scripts.
URL:
Power BI implementation planning: Data gateways - Power BI | Microsoft Learn

 I prefer to recommend you to use a Fabric notebook instead of a personal gateway. Not only is this the official recommended solution, but you will also enjoy the better performance and additional features that notebooks offer.
You could write and run Python code on the notebook and write that data to Onelake.
Use OneLake data in Power BI, doing so avoids having to configure a personal gateway.

Luckily, I have also found other issues on the forums that are related and have been resolved, so I hope this helps.
URL:Solved: Using Python in Power BI without Personal Gateway - Microsoft Fabric Community

I hope my suggestions give you good ideas, if you have any more questions, please clarify in a follow-up reply.

Best Regards,

Carson Jian,

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.