Hi,
Having weird problem whereby a query I'm having simply isn't processing, whereby it is simply saying it is waiting for the Snowflake server. My data model has two tables - the first one is relatively simple, it has nothing more than a list of unique reference numbers, each with a date. This one processes fine. The second one is a bit more complex but still not massive and not overly complicated in itself - it takes a bunch (~1m) of rows, cuts down to maybe 20 pertinent columns, has the other table joined in, has a couple of simple custom columns created based on the value that's brought in, nothing major. The preview will complete fine in the query editor, but when trying to get things to update in Desktop itself, it just never gets started.
By commenting out the back end of the query until it completes, and then adding in things line by line, I've identified the step of the query which is causing the problem - this is the part of the query which causes the problem:
#"Merged Queries" = Table.NestedJoin(#"Filtered Rows", {"POLICYNUMBER"}, Cancellations, {"POLICYNUMBER"}, "Cancellations", JoinKind.LeftOuter),
#"Expanded Cancellations" = Table.ExpandTableColumn(#"Merged Queries", "Cancellations", {"CancelDate"}, {"CancelDate"}),
If I include just the first line, the query completes. If I include the second line as well, the query just stalls at that point and never starts (but, as stated, only when actually loading data into Desktop - refreshing the preview within Power Query works). Does anyone have any insight as to why this would be the case and possible fixes?
