Skip to main content

    Power BI

    New

    hidden sheet

    Vote (12) Share
    Xavier Fantin's profile image

    Xavier Fantin on 14 Oct 2015 15:26:47

    PowerBI should be able to get source from an hidden Excel sheet without having to unhide it

    Comments (2)
    Xavier Fantin's profile image Profile Picture

    02b808d3 f1a3-477c-8216-bb32585a7dec on 05 Jul 2020 23:24:13

    RE: hidden sheet

    I have figured out how to do this out of Excel directly and Excel files in folders but not out of Excel files in a SharePoint folder.

    Xavier Fantin's profile image Profile Picture

    545338cc d7b7-471b-b5b1-35122fc8d787 on 05 Jul 2020 22:16:33

    RE: hidden sheet

    Hi,

    this is possible by using the Advanced Editor but only using scripting. Good luck!