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.

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

    That's right, I don't get an error message but I do get an authentication request every time.
    I couldn't find the option for Browser authorisation in Ofiice 365,
    I'll do some research to see if it's possible.

    Thank you

    Best regards

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

      It's this one: