Get And Prep Your Data For Power Map. Fix your data in the source such as an Excel worksheet table or a SQL Server database and then refresh your data directly from the Power Map ribbon by clicking Home Refresh Data. Get and prep your data for Power Map Structure your data.
Although ArcGIS for Power BI has functionality that provides a location on the map based on the available location data there are a few ways you can prepare your data before you add it to the map to help ensure accurate results every time. Navigate to the downloaded file called Locationsxlsx and open the file by clicking Open in the bottom right hand corner. Fix your data in the source such as an Excel worksheet table or a SQL Server database and then refresh your data directly from the Power Map ribbon by clicking Home Refresh Data.
Power Map will capture your current insight as a scene in your tour and you can continue exploring without worrying about losing that.
Click on Launch Power Map and here we go. Shapefiles and raw GIS data for making your own custom maps. Drag the Shape Map visual onto your Power BI canvas and add the dataset which contains your common linking fields into the Location field well and adjust the formatting options. Open Power BI Desktop.