How to combine after connecting SharePoint folders excel using ODATA

[avi081265]

Hello

Using ODATA, I am able to fetch SP2016 SharePoint Folders and excel. Later I also filter excel file. Now I want to combine all these excel and load the excel's data.

I did not found any combine option.

Please let me know If I am missing anything

Avian 

[edhans · Accepted solution]

I could be wrong but I do not think the ODATA connector can combine files for SharePoint. You have to use SharePoint.Files or SharePoint.Contents to get that functionality.

[avi081265]

Hello,

I tried SharePoint.Files, but looks like I am missing something. See my other post and please advise

Data from multiple excel from SharePoint document ... - Microsoft Power BI Community

[edhans]

I just posted there @avi081265 . Unless you object I will mark my above answer as the solution as it did resolve this particular issue.