Forum Discussion

Mederic's avatar
Mederic
Icon for Post Patron rankPost Patron
2 years ago

SharePoint path not working

Hello, I'm trying to connect to a SharePoint folder in Power query (Excel 365). I get an error message like this: Incorrect request (400)....etc For information, the path is very long with many ...
Need Help
Mederic's avatar
Mederic
Icon for Post Patron rankPost Patron
2 years ago

Hello christinepayton ,

 

Thank you for another interesting suggestion.
I've just tested it with the Odata connector but unfortunately I didn't get any results.
I'm going to try it tomorrow from our company connection because at home I have to get special approval to access SharePoint (connection security via smartphone).

I will test this tomorrow from my office

For information, yesterday I said that the full URL with the Excel file works. I'll just point out that it's with a Web connector.
Have a good evening

 

Best regards