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
5 Replies
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
Is it possible to auto hide rows in the power query editor if the rows are hidden in excel?
MatthewFiero
Hi, did you find an answer? I also want to prevent Power Query from importing hidden rows...
ThanksHi. I did not and I believe I ended up taking an entirely different approach.
Sorry I couldn't be of any assistance.
Matthew
