Forum Discussion
API 2.0 ViewMode Issue
Hi SliderUK
Most likely a bug not a permanent behavior since you are already using it. In theory this should ignore the default view and return all items.
Service behavior is not consistent with expected API behavior. Desktop working fine confirms it's service side issue.
There are intermittent issues where service falls back to default view.
You can raise a support ticket if still the issue persists
https://community.fabric.microsoft.com/t5/Desktop/Cannot-create-support-ticket/td-p/1160834
Super UserHi SliderUK
It is a behavior change with SharePoint connector API 2.0.Power BI Service is respecting the SharePoint list’s default view even when ViewMode = All
Desktop pulls all items correctly. Service sometimes falls back to Default View of SharePoint list resulting missing data unless default view = All
So approach is you can set SharePoint list Default View = All Items and ensure no filters or row limits in that view or in Power Query avoid relying on ViewMode and use SharePoint.Tables(...) instead of list-specific connectors or recreate connection using SharePoint Online List connector and republish