Power Query Header Format Change on Refresh

Kirk P.

New member
Joined
Nov 4, 2016
Messages
10
Reaction score
0
Points
0
Location
Minnesota USA
Excel Version(s)
365
Default header format for data loaded to worksheet is green background and white font. As you can see below, my columns C and D change to black font. I reformat the headers to all match, but every time the query refreshes, columns C and D change to black.

PowerQuery Header Issue.PNG

It's not a show stopper, but it does cause users to think something is wrong with columns C and D, when there is nothing wrong.
 
If you go to the Table Tools --> Design --> Properties, there is an option in there to preserve formats upon refresh. You may want to try toggling that to see if it has any effect on your refresh.
 
Back
Top