Loading from Excel: How can I get hidden rows?

[Anonymous]

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?

[MatthewFiero]

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

[fwde]

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

[MatthewFiero]

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]

Hi, Thank you anyway.
Frank

[PattemManohar · Accepted solution]

@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