Forum Discussion

dd88's avatar
dd88
Icon for Post Patron rankPost Patron
2 years ago
Solved

Data 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 fo...
Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    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

Anonymous's avatar
Anonymous
Not applicable
2 years ago

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