Forum Discussion

Elsie14's avatar
Elsie14
Icon for Advocate I rankAdvocate I
9 years ago

Error connecting to SharePoint online

Power BI desktop fails to connect to a sharepoint online datasource with the following error:   DataSource.Error: SharePoint: Request failed: <URL of my sharepoint site.xlsx>/_api/contextinfo   D...
Need Help
Tips and Tricks
Tim406's avatar
Tim406
Frequent Visitor
9 years ago

Seeing the same thing this morning with data sources that were working fine last night, but in my case I haven't updated PBI Desktop to the April version yet...

 

Strangely, I can access some items on OneDrive just fine - it's when I try to join queries that things are throwing a rod...

Tim406's avatar
Tim406
Frequent Visitor
9 years ago

...and now we're back in business. A mystery wrapped in an enigma, I guess!

  • Elsie14's avatar
    Elsie14
    Icon for Advocate I rankAdvocate I
    9 years ago

    Mine still not working. Checked with a colleague and his is working fine. Not having problems accessing OneDrive or SPO. Mystery continues...

    • Anonymous's avatar
      Anonymous
      Not applicable
      9 years ago

      Hi Elsie14,

      Do you connect to Excel file on SharePoint Online site? If so, I test the scenario as yours, I am able to connect to Excel file on SharePoint Online site in the April version of Power BI Desktop.

      Are you the owner of the Excel file and have you checked that if there are any issues about your account?

      Thanks,
      Lydia Zhang

      • Elsie14's avatar
        Elsie14
        Icon for Advocate I rankAdvocate I
        9 years ago

        I do. However it seems completely random. About an hour ago it worked (did not change anything).  Hoever if I move the folder to another destination on Sharepoint Online (where I have access) I get the same error again.