Get certified for free when you join Fabric Data Days 2026 and dive into Fabric, Power BI, SQL, AI, and other essential data skills.
Join nowData Days is here! Join us now for 60+ days of learning, challenges, and connection. Learn more
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?
Solved! Go to 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 Rows
Data in Power BI
Proud to be a PBI Community Champion
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...
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
@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 Rows
Data in Power BI
Proud to be a PBI Community Champion
Don't miss out on Data Days, June 15 through August 7. Learn Fabric, Power BI, SQL, AI and more.
Check out the May 2026 Power BI update to learn about new features.
| User | Count |
|---|---|
| 23 | |
| 21 | |
| 20 | |
| 18 | |
| 13 |
| User | Count |
|---|---|
| 58 | |
| 50 | |
| 38 | |
| 31 | |
| 27 |