Python / power bi services / gateaway personnel

[JPDUVAL76]

Hello, I have a question. I used a Python script to retrieve data in Power BI Desktop. Once published, I installed a personal gateway on a server with Python and the necessary packages for my code. If I refresh the dataset from my laptop while connected to the server where the gateway is installed, it works. However, if I disconnect from this server, the refresh doesn't work, and Power BI Services indicates that the gateway is inaccessible. So my question is, is there a manipulation or should I perform the refresh manually? In that case, I don't see much value in using Power BI Services.

thanks

[Anonymous · Accepted solution]

Hi @JPDUVAL76 

@lbendlin  Thank you very much for sharing!

Yes, if your gateway is installed on a server that is always on and connected to the internet, it should work normally. However, there are some other factors that might affect the gateway’s performance and availability, such as:

The network bandwidth and latency between the gateway and the data sources, and between the gateway and the cloud services.

The hardware specifications and resource utilization of the gateway machine, such as CPU, memory, disk, and network.

The configuration and maintenance of the gateway, such as updates, firewall rules, proxy settings, and cluster settings.

To ensure that your gateway works reliably and efficiently, you should monitor and optimize these factors regularly.

You can use the Power BI Admin portal or the Power Platform Admin center to view the gateway status, performance metrics, and error logs. You can also use the Power BI Gateway Diagnostics tool to troubleshoot common gateway issues.

Regards,

Nono Chen

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

[JPDUVAL76]

Hello, thank you for your response. My gateway is not on my PC but on a server. This means that normally, if the server stays active, it should work, right?

[lbendlin]

Python Scripts mandate the use of a personal gateway. They won't work with an Enterprise gateway.

[aj1973]

Hi @JPDUVAL76 

that's the cons when using personal Gateway in your own machine. Once the machine is disconnected or truned off then the Gateway becomes inaccessible.

[lbendlin]

I don't think the disconnection is the (primary) issue but yes, the personal gateway is an app that needs to keep running.  (Enterprise gateway is implemented as a service and doesn't need a logged-in user).