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 ,

Sorry for the late return,
I tested today at my office with the "ODATA" connector but unfortunately I can't connect. It keeps asking me to sign in to an account.

Thanks anyway for your help

Best regards

christinepayton's avatar
christinepayton
Icon for Most Valuable Professional rankMost Valuable Professional
2 years ago

If it asks you to sign in repeatedly with no error, the fix for that is to go into the Power BI Desktop settings under Security and set it to use your default browser for authentication. I have had this happen to me too at various points... I don't know why it should matter, but it seems to resolve it.