Incremental Refresh is not working on Power BI Service

I got the following error with different Excels files:

DataSource.Error: <ccon>SharePoint: Request failed (https://test.sharepoint.com/sites/test/Shared Documents/file.xlsx/_api/contextinfo): 429. DataSourceKind = SharePoint. DataSourcePath = https://test.sharepoint.com/sites/X. SPRequestGuid = 1ee8c4a0-b06f-3000-e129-926f511f4f59. </ccon>. The exception was raised by the IDbCommand interface.

It is strange because I already got this error and Power BI refresh successfully without changes in the Data, only refreshing again a few hours later. But after applying Incremental refresh, Power BI faills always with the same issue.

M Code

#"Added Custom2" = Table.AddColumn(#"Filtered Hidden Files1", "DateIncrementalRefreshMonthly", each if [Folder Path] = "https://test.sharepoint.com/sites/test/Shared Documents/General/Deals/" then #date(Date.Year(DateTime.Date(DateTime.LocalNow())),1,1) else #date(Date.Year(DateTime.Date(DateTime.LocalNow()))-1,1,1)),
#"Changed Type3" = Table.TransformColumnTypes(#"Added Custom2",{{"DateIncrementalRefreshMonthly", type datetime}, {"Date modified", type datetime}}),
#"Filtered Rows2" = Table.SelectRows(#"Changed Type3", each Date.Year([DateIncrementalRefreshMonthly]) = Date.Year(RangeStart) and Date.Year([DateIncrementalRefreshMonthly]) = Date.Year(RangeEnd)),

I've already seen your link in YouTube and that was my work around to apply incremental refresh with files on OneDrive. (create a custome column before invoke custom function)