Forum Discussion

DuncanP's avatar
DuncanP
Icon for Advocate II rankAdvocate II
10 years ago

SharePoint Online list connection problems from Power BI Desktop

Hi   I've got an odd error connecting to a tenant SharePoint site. When I enter the SharePoint site to pull in data I get the Access SharePoint dialog box, and go to the Organizational Account. Whe...
Need Help
Eric_Zhang's avatar
Eric_Zhang
Icon for Microsoft Employee rankMicrosoft Employee
10 years ago

DuncanP

Cross-Site Request Forgery looks suspicious. As the log captured nothing so I think PowerBI is innocent.

I guess that request to sharepoint site might have been identifed suspicious so the site refused the request, you'd better consult and confirm this on a dedicated sharepoint forum.

How is it going in a different  enviroment, say in your home PC?

DuncanP's avatar
DuncanP
Icon for Advocate II rankAdvocate II
10 years ago

Hi Eric

 

Thank you for your reply. I think you're right in that Power BI is not to blame as such, it seems more to do with Windows and how it connects via OAuth. I've seen the error posted elsewhere online by people using Excel to connect to SharePoint and CRM Online for example (although no one has provided a solution to it as far as I can see).

 

I've also tried it at home, and had the same error. I've got it working by simply clicking "Sign-in" again and again until it finally lets me enter my username, which I suppose is ok, but still leaves me curious.

 

If I do manage to turn up an answer, I'll post it.

 

Duncan

  • Krizz83's avatar
    Krizz83
    Regular Visitor
    9 years ago

    Click "Sign in" x 4 also worked for me. Thanks