Power Query activity is executing but not returning and keeps loading forever

Question

Hi,

Power query activity was working fine until last Thursday (April 18th), now whenever I run it whether by debug or manual trigger, it keeps loading forever. The job itself is executed and the sink files are generated in Blob storage but it keeps loading without returning or moving to the following activity. When I tested by creating the same pipeline in another Data Factory in East US 2, it worked normally. while in Data Factories in East US and US Central and Western Europe is not working. So to summarize: Power query executing but not returning in two different tenants in different zones (East US, US Central, and Western Europe). Yet it works on both tenants in East US 2 region.

Thanks, Yehia

Answer 1

Hi @Yehia

Thanks for the question and using MS Q&A platform.

We apologize for any inconvenience this may have caused. We have checked with our team, and the problem has been fixed. It seems there was a temporary issue that we solved by refreshing the services. If you encounter any further issues, please don't hesitate to reach out to us.

Hope this helps. Do let us know if you any further queries.

---

If this answers your query, do click Accept Answer and Yes for was this answer helpful. And, if you have any further query do let us know.

Answer 2

You can always check the status : https://azure.status.microsoft/en-gb/status

https://azure.status.microsoft/en-us/status/history/

Meanwhile, consider raising a support ticket with Azure. Provide them with details of your findings, including the specific regions affected, any discrepancies in configurations, and any relevant logs or error messages. Azure support might be able to provide more direct assistance or insight into the issue.