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

Yehia 25 Reputation points
2024-04-20T21:47:02.5266667+00:00

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

Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
9,693 questions
{count} votes

Accepted answer
  1. Smaran Thoomu 10,405 Reputation points Microsoft Vendor
    2024-04-24T05:07:06.78+00:00

    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.

    1 person found this answer helpful.

1 additional answer

Sort by: Most helpful
  1. Amira Bedhiafi 16,071 Reputation points
    2024-04-21T08:06:40+00:00

    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.

    0 comments No comments