Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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?
Solved! Go to 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
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.