Forum Discussion
Different record count for MS SharePoint List data connection to Power Bi
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.