Forum Discussion
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. When I click to sign in, it gives me the following:
Sometimes it works and lets me enter sign in details, mostly I get this error.
Has anyone else seen this? Does anyone know what it even means? As errors go it's not that helpful for me to diagnose the root of the problem.
Cheers,
Duncan
Edit: Here is the text of the error for search engines to find: "The service returned a state value that doesn't match the value that was sent. This might indicate cross-site request forgery."
10 Replies
I just experienced the same problem for the first time using the Adobe Analytics connector in PBI Desktop. I have tried to re-connect about 10 times and continue to get that same error message. I tried clearing my cache too. Nothing seems to help.
Before I got this message, I was experiencing intermittent connectivity issues while trying to refresh my Adobe Analytics data. When refreshing the data I got the error: "OLE DB or ODBC error: [DataSource.Error] Maximum retry count has been reached, and the report is not ready. Try increasing the max retry count.."
It seems like Power BI is no longer able to connect to Adobe Analytics with my credentials. I can still log into Adobe Analytics and access my reports, and the login screen in Power BI looks the same as when I log into Adobe Analytics online (Sign in by email: Organizational Account)
I would really appreciate hearing how to resolve this issue. My work is now completely broken with no solution that I can find online.
Having this same issue. Mine started happening about 2 hours ago as well
You could try turning on Tracing and when you get that error check the log.
Hi
Thanks for the reply. I've enabled tracing, but nothing gets added to the log when I click sign in and the error appears.
Incidentally, I also get the error with our own SharePoint Online sites, not just with partners'.
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?
This warning message will occur while edit the credential of dataflows, anybody knows why?
Any thoughts on how to resolve this? My issue is with the Adobe Analytics connector, but exact issue
Few options did not help such as Clearing credentials, doing a fresh query etc.,, Just tried upgrading the next Power BI desktop version available for me, which did the trick.
So, likely I think, reinstalling the Power BI Desktop should do.
