Reading multiple excel files from sharepoint folder

[mrinmoygupta]

Hi 

I'm trying to combine multiple excel files saved in a shrepoint folder. When I try using "Sharepoint Folder" data connection from Power BI desktop I get below message

Details: "Microsoft.Mashup.Engine1.Library.Resources.HttpResource: Request failed:
OData Version: 3 and 4, Error: The remote server returned an error: (404) Not Found. (Not Found)
OData Version: 4, Error: The remote server returned an error: (404) Not Found. (Not Found)
OData Version: 3, Error: The remote server returned an error: (404) Not Found. (Not Found)"

I can browse to the folder and to the files usinh sharepoint!

I also tried WebDAV access and it does not work!

Please help with this. 

thanks in advance.

[mrinmoygupta]

This has been resolved now. The URL to be restriced to subsite and then I can further filter by folder path.

Thanks

[TeigeGao]

Hi @mrinmoygupta ,

It's pleasant that you have solved your problem.

Best Regards,

Teige