Forum Discussion
Post PatronData source spreadsheet has hidden columns and tabs will these be visible in Power BI
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
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 HiddenSheetBest Regards,
Wearsky
2 Replies
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 HiddenSheetBest Regards,
Wearsky
dd88thank you Anonymous yes I will have a look ..