Intermittent Connection Resets with Power BI API via Airflow(Connection reset by peer)

[dwh_engineers]

Dear Power BI Support Team,

We are encountering an issue when using the Power BI API to refresh datasets through Airflow. The problem arises intermittently, where the connection to the API is dropped, and we receive the following error:
ConnectionResetError: [Errno 104] Connection reset by peer

This error occurs during dataset refresh requests via the Power BI API. We've tested the requests through Postman, and they work consistently, but when integrated with Airflow, the failures happen irregularly. We have taken the following steps to address the issue:

1. Increased the request timeout to 60 seconds.

However, the problem persists, and the connection to the API continues to drop intermittently.

We would appreciate any guidance or recommendations on how to resolve this issue.

[Anonymous]

Hi, @dwh_engineers 

May I ask if you have gotten this issue resolved? If it is solved, please share your solution and accept it as solution, it will be helpful for other members of the community who have similar problems as yours to solve it faster.

If the issue is not resolved, please provide more detailed information about the problem you are encountering, and we will do our best to resolve it for you.

I hope my suggestions give you good ideas, if you have any more questions, please clarify in a follow-up reply.
Best Regards,
Fen Ling,
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[SaiTejaTalasila]

Hi @dwh_engineers ,

You can try to send a email to your mail box and based on that email you can use power automate to trigger your datasets /dataflow refreshes.

I hope it will be helpful.

Thanks,

Sai Teja