Data source spreadsheet has hidden columns and tabs will these be visible in Power BI

[dd88]

data source is a spreadsheet.
Users use the spreadsheet daily. I have edited the spreadsheet, and added columns, tabs etc to make available in PowerBI to work with.  The columns. tabs I added are for powerbi purposes only, and not for users input and I would like to hide the columns and tabs. The users are aware of this. I would like to hide the columns and tabs from the users.

In a worksheet tab if columns are Hidden, in PowerBI will the columns be available and display to work with.

If a tab is hidden, in PowerBI will the tab be available and display to work with.

I tested, I hid a spreadsheet tab and performed a data refresh. The result the tab did not display in PowerBI. I unhid the tab, data refreshed and the tab was in PowerBI to work with.

any info on this one?

TIA

[dd88]

thank you @Anonymous  yes I will have a look ..  

[Anonymous · Accepted solution]

Hi @dd88 ,

Could you try to manually connect the hidden table using Power Query?

let

    Source = Excel.Workbook(File.Contents("C:\path\file.xlsx"), null, true),

    HiddenSheet = Source{[Item="<SheetName>", Kind="Sheet"]}[Data]

in

    HiddenSheet

Best Regards,

Wearsky