getting error

[Pranoti98]

Form17:FieldVisit Web.Contents failed to get contents from 'https://naturalcapitalpartners.sharepoint.com/sites/CC/_api/web/lists/getbyid('5156a0d3-ba22-405a-80...' (429):


I am getting this error again and again even all details are correct and data is small too. 


can anyone help me with pls 

[v-aatheeque]

Hi @Pranoti98 

Have you had a chance to look through the responses shared earlier? If anything is still unclear, we’ll be happy to provide additional support.

[v-aatheeque]

Hi @Pranoti98 

We wanted to follow up to check if you’ve had an opportunity to review the previous responses. If you require further assistance, please don’t hesitate to let us know.

[sergej_og]

Hey @Pranoti98 ,
while using Sharepoint content try to use the corresponding Sharepoint connector (I guess likely Sharepoint Folder).
It's a different logic behind this connector compared to the Web connector.

Regrads

[Zanqueta · Accepted solution]

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 🌀.