cancel
Showing results for 
Search instead for 
Did you mean: 
Reply

Stored Credentials being reset to Anonymous

I have mulitple data sources configured in my web service. They are all different endpoints, but the same logic. I use an OData connection to connect to SharePoint Online lists (our lists exceed the lookup column threshold for a sharepoint online list connector). In the past month, these data sources keep failing the scheduled refreshes, giving the error message that reads 'The credentials provided for the OData source are invalid' So I go into Data Source settings, choose 'Edit Credentials' and sure enough, the authentication method shows 'anonymous' instead of 'Oauth2'. SO I change it to Oauth2, sign in using my O365 creds, APply the changes. Then, just for giggles I click 'Edit Credentials' again and its already reverted back to Anonymous. This is obviously why these refreshes keep failing, but I don't know why it is not sticking to Oauth2.

 

I've tried republishing

I've tried replacing the existing file on the OneDrive and using the 'get data' to navigate and load the file from there.

I've triple checked the stored credentials in the source file

I've opened a ticket with Microsoft...no luck there

 

Any ideas?

5 REPLIES 5
Community Support Team
Community Support Team

Re: Stored Credentials being reset to Anonymous

Hi @Caitlin_Knox,

 

I can't reproduce your issue, after I config the credential, it works on myside. Can you share some detail information about this?

 

>>Then, just for giggles I click 'Edit Credentials' again and its already reverted back to Anonymous.

Based on test, current on service side 'Edit Credentials' seems not contains the feature to remember the last operate.

 

Regards,

Xiaoxin Sheng

Community Support Team _ Xiaoxin Sheng
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.



For learning resources/Release notes, please visit: | |

Re: Stored Credentials being reset to Anonymous

Steps Recorder

 

The above link is a steps recorder that I captured the current sequence of navigating to the data source and re-authenticating.

I've tried deleting the Data Source altogether and uploading a fresh source file, reconfiguring but I still get the same error after the first scheduled refresh.

Community Support Team
Community Support Team

Re: Stored Credentials being reset to Anonymous

Hi @Caitlin_Knox,

 

I double check on my datasource settings, it still works.
I'd like to suggest you submit a support ticket for this issue and use "Fiddler" to trace the detail operation steps and send these records to them.

 

Reference links:

power bi support

Troubleshooting Power BI Gateway - Personal

 

Fiddler Trace

Fiddler is a free tool from Telerik that monitors HTTP traffic.  You can see the back and forth with the Power BI service from the client machine. This may show errors and other related information.

 

 

Regards,

Xiaoxin Sheng

Community Support Team _ Xiaoxin Sheng
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.



For learning resources/Release notes, please visit: | |
ategethoff Frequent Visitor
Frequent Visitor

Re: Stored Credentials being reset to Anonymous

I am experiencing a similar problem, and can date its occurrence to the time when Two-Factor Authentication was turned on for my SharePoint Online sources.   Could this be a factor on your end?

MerrettJ Frequent Visitor
Frequent Visitor

Re: Stored Credentials being reset to Anonymous

I'm experiencing the same issue. I cannot have more than one person refresh the dataset as under the Anonymous authentication method the dataset is stated to be configured specifically to myself.

Helpful resources

Announcements
Virtual Launch Event

Microsoft Business Applications October Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

Power BI Helps Homeless and Trouble Youth

Power BI Helps Homeless and Trouble Youth

We spoke with Power BI Super User, Greg Deckler, about his charity work

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Users Online
Currently online: 109 members 1,656 guests
Please welcome our newest community members: