Forum Discussion
Refresh attempt failed due to this error?
Here is another error code. I’m not that great on reading these error codes but hope someone can help me out with this. Also, I can try to explain on what I have it set up to do. I have leadership on the floor to submit 3s audit through Microsoft Form. There may be like total 10 – 20 plus submission per day. I have the power automate to pull every respond to True Operation 3s Audit SharePoint page. They do submit attachments such as photos or videos through the same form and it’s being storage in the same SharePoint. I have this 3s Audit Power Bi pulling information and links from that same SharePoint to provide reports so any leadership can have access to it. They can even click on the links in Power Bi to see the attachments that are storage in the same SharePoint. Also, we have the power bi to set up auto refresh every hour but now we dial it back to refresh every 3 hours. I hope this helps or make sense but please let me know.
{"error":{"code":"DM_GWPipeline_Gateway_MashupDataAccessError","pbi.error":{"code":"DM_GWPipeline_Gateway_MashupDataAccessError","parameters":{},"details":[{"code":"DM_ErrorDetailNameCode_UnderlyingErrorCode","detail":{"type":1,"value":"-2147467259"}},{"code":"DM_ErrorDetailNameCode_UnderlyingErrorMessage","detail":{"type":1,"value":"SharePoint: Request failed: The remote server returned an error: (429). (429 TOO MANY REQUESTS)"}},{"code":"DM_ErrorDetailNameCode_UnderlyingHResult","detail":{"type":1,"value":"-2147467259"}},{"code":"Microsoft.Data.Mashup.ValueError.DataSourceKind","detail":{"type":1,"value":"SharePoint"}},{"code":"Microsoft.Data.Mashup.ValueError.DataSourcePath","detail":{"type":1,"value":"https://truemfg.sharepoint.com/sites/Operations"}},{"code":"Microsoft.Data.Mashup.ValueError.Reason","detail":{"type":1,"value":"DataSource.Error"}},{"code":"Microsoft.Data.Mashup.ValueError.SPRequestGuid","detail":{"type":1,"value":"128b25a0-d052-c000-c3c8-5a6cd3e1b720"}},{"code":"Microsoft.Data.Mashup.ValueError.Url","detail":{"type":1,"value":"https://truemfg.sharepoint.com/sites/Operations/_api/Web/Lists(guid'16fef537-676d-415e-a3d4-dfc615f2617a')/Items(2848)/AttachmentFiles"}}],"exceptionCulprit":1}}} Table: 3s Audit MFG
Still the same thing
429 TOO MANY REQUESTS
You are still bombarding Sharepoint with more requests than it is willing to handle.
- patbyr4 years agoFrequent Visitor
Thanks for the direct info but again I'm sorry this doesn't really help me to understand what exactly I need to do to fix it or adjust. Also, do you know how many request does SharePoint can handle? or is it speed thing that server can't keep up?