Forum Discussion
Power Query activity is executing but not returning and keeps loading forever
Hello,
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
- Hello, we have the same issue with Power Query running indefinitely as of the 17 of April, 2024 in the evening. We use Western Europe as well. On the 19th of April I created a ticket to Microsoft, the ticket number 2404190050001396 but there is no response from Microsoft after the 2.5 days. It looks like the issue is transversal and not only affects us, I kindly recommend to log support tickets to Microsoft and put their numbers in that thread. To Microsoft support: please do something, because your product components are failing now and we see no evidence that there is a progress.
kind regards,
KevinIt was an issue in the service, it's fixed now. At least of East US for me.
https://learn.microsoft.com/en-us/answers/questions/1658414/power-query-activity-is-executing-but-not-returnin
