SharePoint List Keeps Appending In DataSet

[lardo5150]

I am grabbing a SharePoint list in PowerBi.

There are 6000 rows.

When I do a refresh, in PowerBi, it jumps to 12000.

Rinse and Repeat.

For some reason, instead of just refreshing the data, it is taking whats there, and appending it to what I have already.

Did I miss a setting or is there a way to just get a clean refresh each time?

[Anonymous · Accepted solution]

When Access requests list items from a SharePoint list, Access waits a finite period of time for that data to be returned. Specifically, if Access doesn’t receive the data for the given batch after 30 seconds, it aborts the request and may resend the batch as a new request. If Access encounters failures when sending these batches, the program may give up and return an error message.

Some conditions that may cause this issue are:

• There's a problem with the health of the Microsoft SharePoint Server 2019, for example, it runs slowly.
• You have a low-bandwidth connection.
• You have a large or complex SharePoint list or document library.
• There's a long distance between you and the server.
• There are more than 255 columns in the SharePoint list or document library.
• You are throttled when you use SharePoint Online. For more information about throttling in SharePoint Online.

[MFelix]

Hi  @lardo5150 ,

How  are you getting the information from sharepoint? Is it made from a sharepoint folder or just a sharepoint?

Do you have an ID column on your list? check in the PBI if it's doubling the ID.

Can you share more information about the query you are using for the sharepoint list?