Forum Discussion
Refresh attempt failed due to this error?
Hi patbyr ,
As lbendlin said. Are you performing too many on-demand refreshes while configuring scheduled refreshes, resulting in too many refresh requests being sent to the data source. Is it possible to provide information such as screenshots of the refresh history?
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.
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.
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?
Here is the screen shot of it per your request. I hope this is what you are looking for.
I don't think your schedule is the issue. Most likely the data source queries inside your dataset are causing the issue. You can use Fiddler or similar to monitor network traffic when you do a refresh from Power BI Desktop. That will give you an idea how many requests Power BI pushes into the Sharepoint server.
The call limits are specific to each Sharepoint farm. Talk to your Sharepoint Admin about what's configured for your instance.
