none
Folder.files and authentication RRS feed

  • Question

  • Hi,

    I am using trying to use Folder.Files() on a windows share with mixed authorisation. I have access to some of the sub-folder and others I don't. I'd like Power Query to ignore the folders where I don't have access to. How do I do that?

    The error message:

    DataSource.Error: We got the IO error '59' while trying to access the path 'W:\XX\XXXX'.
    Details:
        W:\


    Code:

    let
        Source = Folder.Files("W:\")
    in
        Source

    Monday, November 18, 2019 2:32 PM

Answers

  • Hi Folkert83. There's currently no way to prevent this. But it would make a great feature request on ideas.powerbi.com.

    Ehren

    • Marked as answer by Folkert83 Wednesday, November 20, 2019 9:07 PM
    Wednesday, November 20, 2019 8:56 PM
    Owner