Forum Discussion
DataSource.Error: An IO error occurred while trying to access the file...
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
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
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.
Hi ccsrtw,
I mean recreate .pbix is to click Get Data and choose Folder data source to retrieve data, instead of pasting original Power Query. I want to check if the issue is related to the folder path or Power Query. Please let me know the test result.
Also please try to update the desktop to the newest version 2.40.4554.463.
Best Regards,
Qiuyun YuMorningv-qiuyu-msft,
I updated to the latest version. Went through the Get Data > Folder process and received the exact same error. Does this imply an issue with the path?
Thank you for following up!
Hi ccsrtw,
Did you add any new files into this folder? Except Excel file(.xls/xlsx), Power BI file(.pbix) and Comma Separated Value (.csv) file, please remove other files then try again. Make sure all files are not opened with other applications.
Best Regards,
Qiuyun Yu