Hidden excel sheet not visible in Power BI

[Kiran09]

I'm not able to see the hidden sheet which is present in my workbook, I've data which needs to work upon in Hidden sheet but In Power BI we can't see any hidden sheet, Any resolution to get this data from hidden to Power BI?

[Eric_Zhang · Accepted solution]

---

@Kiran09 wrote:

I'm not able to see the hidden sheet which is present in my workbook, I've data which needs to work upon in Hidden sheet but In Power BI we can't see any hidden sheet, Any resolution to get this data from hidden to Power BI?

---

@Kiran09

Per my test, the hidden sheets are not shown in the navigator UI. As a workaround, in the query editor, you can go back to the source step and drill drill down the hidden sheet.

[JuliaP]

Hi! It seems to work when the source is only 1 excel, but how to automate this process when the source is a folder with different excel files? 

[mikekolba]

A simpler way I came across doing this as a bit of a work-around was to (assuming all your data/sheets/tabs are identical) was to make a dummy sheet that has the tab unhidden with no data in it. Then you can select that one file as the one to use as your reference and select the "unhidden tab" and then it applies it equally to the other files that have the same tab hidden. Seems easier to deal with for someone who may not have alot of experience? (like me lol).