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,

 

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

 

 

Best Regards,

Qiuyun Yu

ccsrtw's avatar
ccsrtw
Advocate I
9 years ago

v-qiuyu-msft - that did it! Thank you! Wasn't able to get past the user level of the sharepoint source (company-my.sharepoint,com/personal/user_company_com/), but it did list all of the files in that directory so just needed to do a bit of filtering to get the one file I wanted.

 

Thanks again!

 

Per usual, this led into another issue. My second query which is going to use the just solved output ("MyFileName") as part of the source (Source = Excel.Workbook(Web.Contents("https://company-my.sharepoint.com/personal/user_tegna_com/Documents/x/xx/xxx/" & MyFileName), null, true),) is now spitting out this error:

 

Formula.Firewall: Query '2nd Query' (step '...') references other queries or steps, so it may not directly access a data source. Please rebuild this data combination.

 

Trying to apply this solution from Ken Puls, but no luck so far: http://www.excelguru.ca/blog/2015/03/11/power-query-errors-please-rebuild-this-data-combination/.