As stated on the Google documentation (below) for interactive maps (https://developers.google.com/chart/interactive/docs/gallery/map#data-format) it is not possible to plot more than 400 points.
Note: The Lat-Long pairs option loads maps much faster, especially with large data. We recommend that you use this option for large data sets. Please visit Google Maps API to find out how to transform your addresses to lat-long points. The map can display a maximum of 400 entries; if your data holds more than 400 rows, only the first 400 will be shown.
It there a way to plot more than 400 points when making an interactive Google Earth map? I have also posted this reproducible example on Stack Overflow which further details my question and provides R code.
Thanks.