Data Source Credentials failing for Sharepoint suddenly (using a Personal Gateway for refreshes).

[mmace1]

Hi, 

I use a Personal Gateway to auto-update my Datasets.  One data source - Sharepoint, is now throwing an error. 

I can log into Sharepoint fine normally, and it refreshes in my local Power BI file, but the online credentials suddenly don't work. 

Oddly, when I check the credentials, they say "Anonymous"

So I'll switch to OAuth2 - it seems to sign in fine, but when I check - it's back to Anonymous (and fails when refreshing of course). 

So I tried "Sign Out & Forget" under OAuth2, and something interesting happened - we have 2 factor authentication (and have for over a month), when I get to the "enter code" step, my code is rejected. 

I'll go for "Sign in another way", and say try text message code - that *appears* to work.   So does approving the request in my Authenticator App.  But then I check - and things are back to "Anonymous" / refresh fails. 

I tried renaming/uploading my Dataset - same issue with that new copy. 

...thoughts?  

[v-yulgu-msft · Accepted solution]

Hi @mmace1,

There is a known issue related to data refresh when using Sharepoint Online as the data source. Please see: https://powerbi.microsoft.com/en-us/support/

Regards,

Yuliana Gu