Forum Discussion
Refresh attempt failed due to this error?
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?
I should have asked that in the beginning - what are you trying to accomplish? Are you using a Sharepoint.Files() or Sharepoint.Contents() connector?
Can you show a sanitized version of your Power Query?
I'm going to try my best to explain on what I have and what it's doing. Below is the screen shot of my power bi report. In the middle of the report, you will find attachment links. I'm pulling the links on where they are from SharePoint. I have this power bi pulling information straight from SharePoint which is where I have people submitting their Microsoft form. In the form has a question where to add attachments. So any attachments add to the form will go straight to the SharePoint. (Form -> SharePoint -> Power Bi)