Forum Discussion

alpol2000's avatar
alpol2000
New Member
4 months ago

SharePoint Online Lists connector Implementation 2.0 - Power BI service refresh bug

Hello,   I have found a bug with the SharePoint Online Lists connector Implementation 2.0.   I have a SharePoint List with 651 records.  In SharePoint Lists I have created a View of this list fil...
Need Help
vigneshkumarcvk's avatar
vigneshkumarcvk
Icon for Resolver I rankResolver I
4 months ago

Hi alpol2000 ,

What you’re experiencing is a known behavior with the SharePoint Online Lists connector Implementation 2.0. When using View Mode = All, the connector in Power BI Service refresh currently respects the Default View set in SharePoint rather than consistently pulling all items. That explains why Desktop shows all 651 records, but after a Service refresh only the 49 records from your filtered default view appear.

  • Implementation 1.0 does not have this issue, which is why results remain consistent there.

  • The product team is aware of this limitation in 2.0 and tracking a fix, though no public ETA has been shared yet.

Workarounds until the fix is available:

  • Set the All Items view as the Default view in SharePoint before connecting.

  • Use the Web connector with the SharePoint REST API to bypass the view dependency.

  • Continue with Implementation 1.0 if you need guaranteed consistency across Desktop and Service refreshes.