Power Query Refresh - Freeze Panes and Auto-size columns

Copper Contributor

Hi All,

 

When I refresh my power queries and have the table set to resize columns on refresh, it works fine...

 

Until I freeze the panes on the table, to allow the top row and first column to stay visible while scrolling.

 

After this when I refresh the power query, all the columns are sized the same (to what seeems to be a default 80 pixels).

 

Is their any way to have freeze panes on but still resize the other columns based on the data when refreshed?

 

Cheers,

 

Stuart

1 Reply

@Stuart_Little 

Interesting finding, looks like a bug. I sent a frown, you may do the same (Help->Feedback->Report problem)