Setting header row height in Power Query

[Larry of Oz]

Hello all,

I have a Power Query with paramaters set so the query can be run based on information related to the month selected in a separate drop down box. Is there a way to set the header row height that will 'stick' even when the query is refreshed? If I manually set header height to 30, once I refresh the query it reverts to 15.75

Thanks in advance if anyone knows of a solution for this, I'm new to PQ but keen to learn. Advice appreciated!

Kind regards, Lauren

 

[smozgur]

Click in a cell in the resulting table on the worksheet, so it is the active table now.

Ribbon->Data->Properties, and uncheck the Adjust column width property.

It sounds like it stands for the column width, but also keeps the row height as I can see. See if it will help in your case.

 

[Larry of Oz]

Thank you smozgur. Yes I did try that, but sadly it didn't work. Appreciate you taking the time to reply. It may not be possible, which is odd, because you can set the column width and that stays consistent on refresh. No worries, it was just an aesthetic wish, but it's always good to know what options are available.
Have a great day, cheers

 

[smozgur]

You’re welcome. I am sorry to hear it didn’t work for you. Honestly, I didn’t know if it works for height as well, so I tested it before replying and it actually worked for me. The only difference is that I am using 365. Perhaps the development team thought that it is missing and included it with the width setting in the 365 version.

Thanks! You have a great day too!