Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Grow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.

Reply
jthomson
Solution Sage
Solution Sage

Expansion of merged column never completes in Desktop

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?

2 REPLIES 2
v-xuxinyi-msft
Community Support
Community Support

Hi @jthomson 

 

According to your description, the problem you are experiencing is as follows: You have 1M rows of data, which are displayed normally in Power Query, but clicking Refresh in Desktop is not effective.

 

To better help you, is there any relevant error message? If so, would you mind sharing them?

 

Best Regards,
Yulia Xu

There is no error message, it just hangs saying waiting for our Snowflake server and nothing happens

Helpful resources

Announcements
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.