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)

This has not much to do with either your Premium license or the hourly refreshes.  Your issue is that your data source refuses to cooperate because you have sent too many requests its way. Talk to whoever maintains that Sharepoint farm.

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

Here is the screen shot of it per your request. I hope this is what you are looking for.