Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Loading from Excel: How can I get hidden rows?

Hello,   I am trying to load some data from excel and I need in my Power BI report a row which is hidden. Is there any way to do this?  
Need Help
  • PattemManohar's avatar
    PattemManohar
    7 years ago

    Anonymous  It should import the hidden rows by default without any extra settings. I've tried the same and it's working.

     

    Excel Source with Hidden RowsData in Power BI

MatthewFiero's avatar
MatthewFiero
Icon for Helper I rankHelper I
5 years ago

Is it possible to auto hide rows in the power query editor if the rows are hidden in excel? 

  • fwde's avatar
    fwde
    Icon for Advocate I rankAdvocate I
    5 years ago

    MatthewFiero
    Hi, did you find an answer? I also want to prevent Power Query from importing hidden rows...
    Thanks

    • MatthewFiero's avatar
      MatthewFiero
      Icon for Helper I rankHelper I
      5 years ago

      Hi. I  did not and I believe I ended up taking an entirely different approach. 

       

      Sorry I couldn't be of any assistance. 

       

      Matthew

      • fwde's avatar
        fwde
        Icon for Advocate I rankAdvocate I
        5 years ago

        Hi, Thank you anyway.
        Frank