Power Query Header Format Change on Refresh

[Kirk P.]

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.



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.

 

[Ken Puls]

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.