Skip to main content

Number of rows of data supported

Most Power BI visuals support up to 30000 rows of data. However, with Icon Map Pro it is possible to exceed this limit.

In the Data Layers formatting settings, you will find a card labelled "Data Rows". In here, the number of rows loaded into the visual can be modified up to 480000s rows, in multiples of 30000.

480000 rows

Exceeding 30000 rows should be done with caution as it may result in a slow rendering map. Also to be noted, Power BI does not currently support conditional formatting on items beyond 30000 rows.

Use new data load logic​

alt text

The functionality provided by Power BI's API to load large datasets doesn't support conditional formatting for rows beyond the first 30000. This new logic adds this capability. The ability to revert to the previous logic is provided for backwards compatibility.

Performance Tips​

The more items that are displayed on the map, the slower the map will render. There are a number of things that can be done to mitigate this.

Tooltips & Selection​

If tooltips are not required for an item, then disabling them will decrease the time required to draw the map. Similarly, if an item isn't required to be selected, then disabling selection will significantly decrease map drawing time.

Images​

Images are slow to draw on the map. Consider replacing them with simple polygons, or circles if possible. SVG images render slower than PNG images.

GeoJSON / KML / Shapefile Layers​

Matching feature properties against your Power BI data​

By default Icon Map Pro will check every property in every feature in your shape file against your Power BI reference data, to see if there's a match. If there are a large number of fields, or a large number of rows of data, then this can take a long time. It is possible to specific a specific field to match against. Enabling this will reduce the amount of time required to draw GeoJSON / ESRI and KML shapes.

Shape Complexity​

Simpler shapes with fewer points will draw faster than complex shapes. Consider using tools such as QGIS or MapShaper to reduce the complexity of your shapes.

Vector Tiles​

Consider using Vector Tiles, either self hosted in GeoServer or with third party providers such as Mapbox and ArcGIS. Vector tiles only load the shapes that are currently being viewed on the map at that time. This means it's possible to draw very large number of shapes (up to 180000) without having to load all of them into a GeoJSON file at the same time.