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?





1 Reply


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