Accessing files from WebDAV (folder)

[dkrof]

Hi everyone

I am trying to connect to a WebDAV source (folder containing tons of Excel files). Thus far I can connect to the source in two ways: 

1. Folder: I can see the contents but cannot access it.
2. Files: Can access file contents.

But there are too many and names will chance, hence it is not really feasible for me to connect them individually.

Can any of you kind people in this forum point me in the right direction? I am confident that there must be a way to connect to the folder as well as its content somehow (kind of like the solution described here for files in a Sharepoint folder). I just cannot think of any new ways to try.

NB: I have posted a very similar post in the PQ-subforum as well. The first suggestion there was to move the files to OneDrive/Sharepoint which is not an option, as the company will not allow to move their archive system. The second suggested solution was a costum connector which I was not able to set up. I hope someone here might have another suggestion.

Thank you very much in advance!

[v-yetao1-msft · Accepted solution]

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.