Forum Discussion

mrinmoygupta's avatar
mrinmoygupta
Frequent Visitor
7 years ago

Reading multiple excel files from sharepoint folder

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.

Need Help

2 Replies

  • mrinmoygupta's avatar
    mrinmoygupta
    Frequent Visitor
    7 years ago

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

     

    Thanks