getting error

Hi Pranoti98 

The 429 error indicates that the SharePoint API call is being throttled due to exceeding request limits. Even if the dataset is small, SharePoint applies throttling when too many requests are made in a short period or when the method used is not optimised.

Try reduce calls and use controlled pagination:

Source = Web.Contents(
    "https://naturalcapitalpartners.sharepoint.com/sites/CC/",
    [
        RelativePath = "_api/web/lists/getbyid('5156a0d3-ba22-405a-80...')/items",
        Headers = [Accept="application/json"]
    ]
)

Please check que official reference:

Web.Contents - PowerQuery M | Microsoft Learn

If this response was helpful in any way, I’d gladly accept a 👍much like the joy of seeing a DAX measure work first time without needing another FILTER.

Please mark it as the correct solution. It helps other community members find their way faster (and saves them from another endless loop 🌀.