SharePoint Excel File Data Source Issues

[CarloA93]

I've found that if I use Excel files on SharePoint (using the SharePoint folder connection in Power BI), that the connection breaks if I add any other files into that SharePoint (removing them resolves this). Is there any way around this? Or, is there a better datasource that can be easily be updated by non-power users we can utilize, hopefully free but if we need other licenses that's okay too.

[ChrisMendoza · Accepted solution]

@CarloA93 - Not sure if this is the issue but I usually grab Excel files within SharePoint as the below image. You should only need the Source line as the subsequent lines are generated by the GUI as you click through to find the Excel file.