Forum Discussion
Refresh attempt failed due to this error?
Hi patbyr ,
According to this problem, refer to the following blog to see if the solution is helpful to you:
If the problem is still not resolved, please provide detailed error information and let me know immediately. Looking forward to your feedback.
Best Regards,
Henry
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
I'm not sure what exactly is going on but I am struggling to understand why this is happening. From what I'm seeing here is that it is still doing the updates but some of it goes through while some others pop up with an error. Here is the thing, the error code isn't the same one everytime. It's always popping up a different error code everytime. Not all of it are the "429 TOO MANY REQUEST". Please see below where you will find the screen shot of the refresh history along with the most recently error code.
{"error":{"code":"DM_GWPipeline_Gateway_InvalidConnectionCredentials","pbi.error":{"code":"DM_GWPipeline_Gateway_InvalidConnectionCredentials","parameters":{},"details":[{"code":"DM_ErrorDetailNameCode_UnderlyingErrorCode","detail":{"type":1,"value":"-2147467259"}},{"code":"DM_ErrorDetailNameCode_UnderlyingErrorMessage","detail":{"type":1,"value":"The credentials provided for the SharePoint source are invalid. (Source at https://truemfg.sharepoint.com/sites/Operations.)"}},{"code":"DM_ErrorDetailNameCode_UnderlyingHResult","detail":{"type":1,"value":"-2147467259"}},{"code":"Microsoft.Data.Mashup.CredentialError.DataSourceKind","detail":{"type":1,"value":"SharePoint"}},{"code":"Microsoft.Data.Mashup.CredentialError.DataSourceOriginKind","detail":{"type":1,"value":"SharePoint"}},{"code":"Microsoft.Data.Mashup.CredentialError.DataSourceOriginPath","detail":{"type":1,"value":"https://truemfg.sharepoint.com/sites/Operations"}},{"code":"Microsoft.Data.Mashup.CredentialError.DataSourcePath","detail":{"type":1,"value":"https://truemfg.sharepoint.com/sites/Operations"}},{"code":"Microsoft.Data.Mashup.CredentialError.Reason","detail":{"type":1,"value":"AccessUnauthorized"}},{"code":"Microsoft.Data.Mashup.MashupSecurityException.DataSources","detail":{"type":1,"value":"[{\"kind\":\"SharePoint\",\"path\":\"https://truemfg.sharepoint.com/sites/Operations\"}]"}},{"code":"Microsoft.Data.Mashup.MashupSecurityException.Reason","detail":{"type":1,"value":"AccessUnauthorized"}}],"exceptionCulprit":1}}} Table: 3s Audit MFG (2)
You seem to have a Sharepoint instance that is in general struggling to keep up with user requests
"value":"The credentials provided for the SharePoint source are invalid. (Source at https://truemfg.sharepoint.com/sites/Operations.)"
That's an euphemism for "I'm stressed out, someone help me"
Here is what I'm thinking but I haven't try it yet. I'm thinking about setting this up in a different way due to the fact that I have this Power Bi set up where to update the whole SharePoint into Power Bi which maybe why this is happening. We don't need to update the whole SharePoint into Power Bi since it's already there while we only need to update the new ones going into it. Here is the video that I found in youtube which is what I'm thinking about setting up.
What do you think?
