Forum Discussion
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?
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
Hi, did you find an answer? I also want to prevent Power Query from importing hidden rows...
Thanks
Hi. I did not and I believe I ended up taking an entirely different approach.
Sorry I couldn't be of any assistance.
Matthew
Hi, Thank you anyway.
Frank