Forum Discussion

SliderUK's avatar
SliderUK
New Member
4 months ago
Solved

API 2.0 ViewMode Issue

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.

 

 

Need Help

6 Replies

  • SliderUK's avatar
    SliderUK
    New Member
    4 months ago

    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's avatar
      krishnakanth240
      Super User
      4 months ago

      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's avatar
        v-aatheeque
        Community Support
        4 months ago

        Hi SliderUK 

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

         
  • krishnakanth240's avatar
    krishnakanth240
    Super User
    4 months ago

    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