Forum Discussion
Different record count for MS SharePoint List data connection to Power Bi
When exporting data from SharePoint list via export to Excel or Export to Power BI a different number of records are seen than when Power BI is connected to the SharePoint Online list from within PowerBI, what is the difference?
What are the numbers? The PBI connector can use a specific view for the connection, so make sure you're not using a filtered view there, also the 2.0 connector tops out at 5000 records I think (1.0 does not do this). You could also be on a filtered view when you're exporting from SP to Excel.
3 Replies
What are the numbers? The PBI connector can use a specific view for the connection, so make sure you're not using a filtered view there, also the 2.0 connector tops out at 5000 records I think (1.0 does not do this). You could also be on a filtered view when you're exporting from SP to Excel.
Thank you for the reply, the issue was related to transforming the data in the desktop version of PowerBI. One of the fields is a drop down list that allows multiple selection. Those that had multiple selections created extra records. BTW, record count is about 2100. I will run into the 500 record limit within about a month and will modify to use the 1.0 now. Is there any workaround, the 2.0 ensures that I can pull in all fields?
The 1.0 and 2.0 connector have a very different resulting table structure/column names, so it's probably easiest to just start your query over vs trying to swap it out. I hope MS addresses that limitation at some point, it's frustrating so I basically never use 2.0.
