Forum Discussion

ccsrtw's avatar
ccsrtw
Advocate I
9 years ago
Solved

DataSource.Error: An IO error occurred while trying to access the file...

I'm trying to create a variable query that outputs the name of the file most recently modified in a certain folder. I actually accomplished this yesterday and the output was successful, but when I re...
Need Help
  • v-qiuyu-msft's avatar
    v-qiuyu-msft
    9 years ago

    Hi ccsrtw,

     

    It seems folders exist in SharePoint online, please try the SharePoint Folder data source instead of Folder data source. See:

     

     

    Best Regards,

    Qiuyun Yu

v-qiuyu-msft's avatar
v-qiuyu-msft
Community Support
9 years ago

Hi ccsrtw,

 

From the error message, it seems the file can't be accessed. As you mentioned you have permission to access the file, the issue can be caused by that the file is occupied by other programs or other users. Please use Handle to find all process accessed this file, then kill them to refresh query in desktop to see if issue persists.

 

Best Regards,
Qiuyun Yu

  • ccsrtw's avatar
    ccsrtw
    Advocate I
    9 years ago

    Hi Qiuyun,

     

    I downloaded Process Explorer (Handle w/ GUI), but I honestly have no idea how to identify which processes (if any) to kill. I killed anything related to Excel, but that hasn't helped. Any other tips?

     

    Appreciate the help!

    • v-qiuyu-msft's avatar
      v-qiuyu-msft
      Community Support
      9 years ago

      Hi ccsrtw,

       

      Would you mind recreating a .PBIX file use the same data source to check if the same issue occurs?

       

      Best Regards,
      Qiuyun Yu

      • ccsrtw's avatar
        ccsrtw
        Advocate I
        9 years ago

        v-qiuyu-msft - I created a .pbix file and copy/pasted the code into a blank query:

         

        let
    //Choose folder
    Source = Folder.Files("\\PATH"),
    //filter out all but Excel files
    #"Filtered Rows" = Table.SelectRows(Source, each ([Extension] = ".xlsx")),
    //sort in descending order by date modified
    #"Sorted Rows" = Table.Sort(#"Filtered Rows",{{"Date modified", Order.Descending}}),
    output = #"Sorted Rows"{0}[Name]
in
    output

         

        Received an identical error:

         

        DataSource.Error: An IO error occurred while trying to access the file '\\PATH'.

        Details:

             PATH

         

        Really odd. Frustrating that this worked initially and now isn't for no apparent reason!

         

        Again, appreciate all of your help.