Forum Discussion
Helper IIIHow to combine after connecting SharePoint folders excel using ODATA
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
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.
3 Replies
- edhans
Community Champion
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.
avi081265Hello,
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