For those that have experience with the Map capabilities in SQL Reporting Services, you know Microsoft defiantly had a lot of room for improvement. With PowerBI, Power Map greatly increases the mapping visualizations at your disposal. It can produce visualizations by plotting up to a million data points in the form of columns, heat maps, and bubble charts on top of a Bing map. However, you must have an internet connection for this to work.
Setting it up
Maps allows you to visualize the locational information supplied by the data source. As with any successful data analysis effort, it is critical that you establish the proper data source for the PowerView. Power Map can use one of two sources of data for the maps: an Excel table or a table contained in a Power Pivot data model. For PowerMap to work, you must use a data source that contains location data, such as Latitude and Longitude. Although Latitude and Longitude is not a locational data you can use (Address fields work as well), it it’s the most precise.