Forum Discussion
getting error
Form17:FieldVisit Web.Contents failed to get contents from 'https://naturalcapitalpartners.sharepoint.com/sites/CC/_api/web/lists/getbyid('5156a0d3-ba22-405a-805c-8d5ff5f89b7f')/RenderListDataAsStream?Paged=TRUE&p_SortBehavior=0&p_ID=971255&ix_Paged=TRUE&ix_ID=971255&ix_Key=363459A77428ED156AA3E4679FFD14E1&PageFirstRow=130318' (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
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 🌀.
4 Replies
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 🌀.
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.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.
