Forum Discussion

robertopolo's avatar
robertopolo
Regular Visitor
5 years ago

Sharepoint List 20.000 Rows

Hi, I am trying to query a Sharepoint list that has around 20,000 items. I use the Sharepoint Online List connector available in Power BI Desktop. When I try to select the list, I get the following error:

 

Web.Contents no pudo obtener el contenido de 'https://tecnicomcdn.sharepoint.com/sites/praguassistemas/_api/Web/Lists(guid'62008858-b1c9-417e-928e-168c51797de0')/RenderListDataAsStream' (500): Internal Server Error.

 

Could someone help me understand what is happening?

Need Help

3 Replies

  • PhilipTreacy's avatar
    PhilipTreacy
    Super User
    5 years ago

    Hi robertopolo 

    (500) Internal Server Error is an error at the web server, there can be numerous causes but often it's due to a request taking too long.

    Web servers have a limit to how long a request can be processed.  If that limit is exceeded, you get this error.

    It may be that it's taking too long to process/list your 20,000 items.  Is there any way you can reduce this list size and test if the size if the cause?

    Otherwise I'd be looking to raise a fault ticket with Sharepoint.

    Regards

    Phil

    • robertopolo's avatar
      robertopolo
      Regular Visitor
      5 years ago

      The funny thing is that the error is displayed about 5 seconds after the query started. I had already connected to the list when it had less than 5000 items. Then the almost 20,000 were completed and I opened the PowerQuery to make some adjustments to the data and when I pressed the load and apply button it showed me the error that I comment.