Get only unhidden columns in excel without manual selection in Query

[jeongkim]

Hi,

Is there any option to not get hidden columns in excel?

I have 100 columns such a lot but only 10 columns in use so I want to get only 10 of them. 

* the columns orders or format is chaning often so can't expect which columns would be hidden/unhidden every time so manual column selection in query won't help.

my previous question still unresolved. 

https://community.fabric.microsoft.com/t5/Desktop/Getting-data-only-from-unhidden-row-columns/m-p/38...

[Idrissshatila · Accepted solution]

Hello @jeongkim ,

you can use the choose columns in power query to only choose the columns you need.

check it out https://learn.microsoft.com/en-us/power-query/choose-remove-columns