Suddenly, Data Source Credentials for Sharepoint not working -

[mmace1]

Hi, 

Sharepoint works fine when connecting from my local Power BI File. 

It had been working on the service too for the last ~5 weeks, but now I'm getting an error. 

 

When I go in to check the authentication for Sharepoint, it shows Anonymous for some reason

I'll go to sign in via the OAuth2 method - and it appears to work.  But right after "signing in" I'll check - and it's back to Anonymous. 

I also tried, under OAuth2, to "sign out & forget" and start from scratch. An odd thing, when getting to this step

 

The code will be rejected.  I can 'Sign in another way' - say use the text message version of our code, and it works fine.  Or seems to, but once finished, I'll check - and things are back to 'Anonymous'

We've been using 2-factor authentication for weeks, so it's odd it would have an issue now (if the 2-factor *is* the root issue). 

I did try renaming/reuploading my source file into a new dataset - that one exhibited the same issues.  

Thoughts? 

[Anonymous · Accepted solution]

Hi @mmace1,

It sounds like a known issue power bi team already listed on support page, please take a look at following link if your scenario suitable for that description:

Power bi Support

Some customers that have more than 1,000 documents in a Sharepoint Document Library may experience issues refreshing reports when using Sharepoint Online as the data source. As a workaround, customers can refresh from Power BI desktop. Engineers will be deploying a fix starting 11/12 and expect it to be in all regions by end-of-day 11/17. Next update @ 11/16/18 at 5:00pm PST. 

Regards,

Xiaoxin Sheng

[VEG_Admin]

Can you provide a more specific link to the solution?  I can't find anything on the PowerBI support page that you linked to that addresses this issue at all.  Is is possible this is related to two-factor authentication being enabled?

[mmace1]

In my case - the issue 'fixed itself'. Or as the quote above says, Power BI engineers rolled out a fix, so a few daya later things started working again.

[VEG_Admin]

Did you have to start a support ticket, or did you just post it to the message board?  It definately looks like we are having the same issue that you were having, but maybe it is something different.  Do you still have 2 factor enabled?

[mmace1]

Yes still have 2 factor.

It turned out not to be an issue specific to us, but some more general issue with the service. No support ticket. They just already knew of the general issue and eventually fixed things on their end.

ie my posting here didn't help at all.