Notifications
Clear all
Power Query
3
Posts
3
Users
0
Reactions
73
Views
Hi,
I want to change my headers to 2 rows and shrink its width after loading from PQ, but every Refresh it reverts back to original size etc.
I have the "Preserve cell formating" in my "Table Design->Properties" checked.
Regards,
Ayal Telem.
Posted : 03/10/2023 8:37 am
Hi,
Some of the problem I was able to solve, as the headers row-splitting was coming from the original file, but the width I cannot see where it gets it from, let alone it shouldn't overwrite local formating (destinatio file) with the global (source file).
Regards,
Ayal Telem.
Posted : 03/10/2023 8:46 am
Hi Ayal,
I suspect there is something in the columns that are changing that is driving the re-sizing because the Table properties setting should fix it.
Mynda
Posted : 04/10/2023 5:25 am