How to get data from a Sharepoint subfolder using Excel Power Query?

I'm trying to use Excel's Power Query to pull data from a bunch of .csv files saved on my company's Sharepoint. We use different folders and subfolders to categorize data from different studios. I n...