API 2.0 ViewMode Issue

[SliderUK]

Hi All

I've been having issues recently with Published Service in that it uses the Default ViewMode instead of All, anyone else had this issue?

It's happened now on two different environments for reports that have been working fine for over a year.

So you refresh on desktop and it shows you all the data, then you publish and view online and most of the data is missing. Then you realise that the data you get is the same as the default view in the SharePoint List. Change my default view in the SharePoint list to All and then the report shows all the data.

I've checked the viewmode is set to 'All'. Is there something else I need to set?

Thanks in advance.

[SliderUK]

Hi Thanks for your reply.

Is this behaviour permanent? or just a bug which will get fixed?

I already use SharePoint Tables to get my data, this is my first step:

= SharePoint.Tables("sharepointurl.....", [Implementation="2.0", ViewMode="All"])

Thanks

[krishnakanth240 · Accepted solution]

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

[v-aatheeque]

Hi @SliderUK 

Following up to confirm if the earlier responses addressed your query. If not, please share your questions and we’ll assist further.

[v-aatheeque]

Hi @SliderUK 

Have you had a chance to look through the responses shared earlier? If anything is still unclear, we’ll be happy to provide additional support.

[SliderUK]

Going to raise a support ticket as its just happened on another environment.

[krishnakanth240]

Hi @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