Forum Discussion

4 Replies

  • Viswa11's avatar
    Viswa11
    Frequent Visitor
    2 years ago

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

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      2 years ago

       

      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's avatar
        Viswa11
        Frequent Visitor
        2 years ago

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