Hi, I would like to ask for help with right displaying count from data placed in a Sharepoint list (connection between PBI and Sharepoint).There are 39 items in the list on Sharepoint, but the ID starts on the number 18 (ID from 18 to 56). Previous 17 items were for testing - fields, notifications etc. These items have been deleted and I do not see them anymore in the list on Sharepoint.If I try to add these items to the table in the PBI, the total count of IDs shows the number 56, but there is only 39 items (and some items are also excluded). Weird is, that if I add a new column with IDs without counting next to the IDs column with counting, it is displayed more than one ID in some items, but the ID name is still only one (picture below).Could anyone help me with it? Do I something wrong? Thank you in advance.Libor

It looks like the default aggregation on your ID column is Max. Change it to count or distinctcount in the field well (pull down on the arrow for that column). Regards, Pat

PBI does not count items (rows) from list on Sharepoint correctly

Forum Discussion

Related content

Sharepoint list mirroring

Power BI Sharepoint Online List Connector 2.0 returning 2000 rows

Limit on rows from SharePoint List

Extract Data from sharepoint

SharePoint Access