404 Error when trying to connect to a Sharepoint File within a Sharepoint Folder created by another

[EricKautz]

I have been in the process of building and testing a new power BI report that the data query is pulling in numerous data feeds from excel and csv files that are saved in multiple Sharepoint Folders. I have been saving some of these files in a testing subfolder I created as well as some other data files that are being saved by different teams and those team created those folders. I have had no issues until today. We just did a data migration from network drives to Sharepoint. In doing so, our primary SharePoint Site Owner started creating folders in Sharepoint and moving the files from the network drives over to these folders. I have previously been moving these files as well from the network drives to my created folders so I can continue testing. Today, the first files were moved to our departments Sharepoint, so I wanted to go into Power Query and update the navigation steps to pull files from the newly created Sharepoint folders instead of my sharepoint test folders. I can go through navigation steps using Sharepoint.Contents to get directly to the sub folders where the new files are saved. But when I filter down and get the step where click "Binary" to load the data preview, I am getting a 404 error

"DataSource.Error Web.Contents failed to get contents from https://--------------------------/$value' (404): Not Found Details:

Details:

DataSourceKind=Sharepoint

DataSourcePath=https//sharepoint/sites/abcd

URL=filepath/$Value"

I tested the issue by creating a subfolder within this folder and tried to connect, but could not still connect and got the same error. I then created another folder outside of this folder and was able to connect successfully, so I am think maybe its something access related that is preventing to connect. Problem is, for the entire Sharepoint Library I have full control access so that should not be blocking me. 

I have been able to get around this issue by creating a power automate flow that copies any new files added to these folders created by others and moving the files to my already working test folder and that seems to be working but would like to avoid this step. Any assistance would be greatly appreciated.

[EricKautz · Accepted solution]

I believe I figured out my issue. The folder name where the files were housed had "%" in the name and Power Query did not like that. Once I changed the name, I was able to access my data.

[Anonymous]

Hi @EricKautz ,

Based on your description, first of all, even though you have full control permissions for the entire SharePoint library, the permissions for certain folders or files may be set individually, rendering them inaccessible to you. You can check the permission settings for these folders to make sure you have enough permissions to access these files. Second, the file paths may have changed during the data migration process, causing Power Query to fail to find the files correctly. You can check to see if the file paths are correct, especially if the paths in the URLs match the actual SharePoint paths.
You can also change the SharePoint.Files() function in the edit field to SharePoint.Contents() as mentioned in the following documentation

Solved: Datasource error (404): Fail to connect sharepoint... - Microsoft Fabric Community

Best regards,
Albert He

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

[EricKautz]

I've already the permission for the folders and I have access to the them and the files. I even tested this by having another co-worker create a seperate folder outside of the main new folder where all these files were moved to, put a file in there, and when I tried to connect to it, got the same error. Regarding your 3rd point, I always use SharePoint.Contents().