How to import files from different paths

Hi KWilkinson02 ,

please start with importing just 1 file via the "From Excel-Method". Then check the M-code that has been generated. In the following steps you will replace the path to that file with the reference to a column. So the way that path has been written needs to match one of the columns from your solution.

Please check out this blogpost, which describes the general method (although it is for multiple webpages, the general princple is the same): https://www.thebiccountant.com/2018/02/10/web-scraping-1-combining-multiple-tables-from-one-page-in-power-bi-and-power-query/