Getting data only from unhidden row/columns

[Anonymous]

Hi

Is it possible?

I only need shown coluns and rows, how can we filter it on query?

[Viswa11]

Hi @Anonymous ,
Can you add more details like what is the source excel? and what you want to visualize!

[Anonymous]

as snapshot, current query fetch all the hidden/unhidden columns but I need only unhidden ones(column 9 only). Column 10/11 are hidden on excel so I don't need them in query neither. 

[Viswa11]

Hi @Anonymous ,
In power query editor click on below option marked in image then click on choose columns select the columns you want.

[Anonymous]

This kind of manual selection won't help. 

need to fetch dynamially only shown in excel.