Forum Discussion

Elsie14's avatar
Elsie14
Advocate 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

 

Does anyone know what this error means? Seemed to be working fine yesterday and before but since I have updated Power BI Desktop this error keeps showing up.

8 Replies

  • Tim406's avatar
    Tim406
    Frequent Visitor

    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

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

      • Elsie14's avatar
        Elsie14
        Advocate I

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

  • Hello, 

    I'm getting the same error, as I have been tried to clear permission and log in again with my credentials but still not working.

    Any suggestion?

     

  • Anonymous's avatar
    Anonymous
    Not applicable

    I had this error and was just able to fix it. Mine occurred from successfully referencing an excel file in OneDrive, then needing to change the folder that the file was in, but keeping the file name the same. 

     

    When I cleared credentials and resigned in I still got the error, but when I clicked "Change Source" in Data Source Settings and put in the new file location path and then cleared permissions and re-signed in, it worked.