Accessing files from WebDAV (folder)

Hi dkrof 

Currently , apart from the several solutions you described above, no other additional solutions can be provided. In Power BI Desktop , you can only load data from multiple excel files in local folder with Excel Workbook or Folder connector. If the columns in multiple excel files are same , you can use Folder connector to load data, then combine and transform data in Power Query. If the columns in multiple excel files are different , you can only load data by Excel connector from excel files one by one .

The link below will teach you how to combine and transform data from multiple excel files in Power BI .

https://sqlitybi.com/loading-multiple-excel-files-from-a-folder-in-power-bi/

Best Regard

Community Support Team _ Ailsa Tao

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