Microsoft 365 and Office | Excel | For home | Windows
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
Done, thank you.
Power maps limit?
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
Anonymous
Hi,
I've imported a dataset of 29 million rows and 3 columns (lat, long, date) through Power Pivot. 3D power maps picks up the columns but when I try to generate the map I get an error "3D maps encountered an error and could not complete the last action".
I don't get this error on smaller data sets of approximately 300,000 rows. Is there a limit to the amount of rows 3D maps can plot?
Microsoft 365 and Office | Excel | For home | Windows
Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.
2 answers
Sort by: Most helpful
-
Anonymous
2017-11-22T23:16:18+00:00 -
Anonymous
2017-11-22T11:35:28+00:00 Hi Ashley,
By using 3D Maps, we can map data and plot more than a million rows of data visually on Bing maps in 3-D format from an Excel table or Data Model in Excel.
The error "3D maps encountered an error and could not complete the last action" is caused by the immense amount of data you were trying to generate the map from.
To answer your question if there is a limit to the amount of rows 3D maps can plot, we suggest posting it to our Excel UserVoice feedback forum. This is the place for users to send us suggestions, ideas, questions and feedback on how to improve.
If you have other concerns, don't hesitate to get back to us.