Forum Discussion
Suddenly, Data Source Credentials for Sharepoint not working -
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?
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:
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
5 Replies
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:
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
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?
- 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.
