Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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?
Solved! Go to 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:
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:
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?
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsUser | Count |
---|---|
86 | |
84 | |
69 | |
67 | |
55 |
User | Count |
---|---|
125 | |
100 | |
90 | |
84 | |
66 |