Enterprise Gateway Not Configured Correctly only with Python in report

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.