Time out Refreshing if using List.Contains in PowerQuery script

[marcobrugna]

Starting from today we are experiencing failures in the reload process if Power query contains a List.Contains command

Processing error:	Timeout expired. The timeout period elapsed prior to completion of the operation.
Cluster URI:	WABI-UK-SOUTH-B-PRIMARY-redirect.analysis.windows.net
Activity ID:	6ffca727-554f-4a04-9489-92e4ea104570
Request ID:	0f6e7951-15ec-6963-307a-5e86c128ab44
Time:	2020-12-16 19:49:29Z

If I'm filtering my table  using List.Contains with values from another table, the reload takes ages and then eventually goes in timeout.

Not sure when it started , but we noticed from this morning.

Is bug introduced by the December Release? Maybe related to the new Dependency query view?

[v-chuncz-msft]

@marcobrugna 

That works fine for me in Service version13.0.15022.58. You may take a look at What is Query Diagnostics for Power Query?