Skip to main content

Mappedin Visual for Power BI

The Mappedin Visual for Power BI provides a simple way to plot analytics events on an indoor map within a Power BI report.

The Mappedin Visual for Power BI is still an experimental product and is not yet available on Microsoft AppSource. While in this state, some features may not behave as intended and are subject to change. Experimental features are being tested together with early adopters to fine-tune them.

Heatmap

Prerequisites​

In order to use the Mappedin Visual for Power BI, customers must have a map built with Mappedin CMS and Mappedin GeoJSON Export credentials. For best results, reference a map with real-time indoor positioning and use Mappedin's analytics as a data source.

Looking to get started? Contact Mappedin for more details.

Installation​

While in experimental state, the Mappedin Visual for Power BI can be downloaded directly from the following link:

Once the project has advanced from its experimental state, the visual will be obtainable from Microsoft AppSource.

Please refer to the Microsoft documentation on importing a local visual into Power BI and follow the instructions there.

Preparing the Data​

When creating a report, ensure that the latitude, longitude, and floor_level columns are correct in the data model. While viewing the data model, select each of these columns and open their advanced settings. They should all be set to a "Summarize by" value of "None".

To find out how to edit the data model, please refer to the Microsoft documentation on editing data models and follow the instructions there.

Setting Latitude to Summarize by None

Configuring the Visual​

In order to render the map and data, the table's columns need to be assigned to fields. In a Power BI report with analytics data, add the visual to the page. From the "Build visual" menu, supply values into their respective fields.

  • Latitude (Required)
  • Longitude (Required)
  • Floor Level (Optional)
    • If a column is referenced in this field, data will be filtered by Floor Level value.
  • Tooltips (Optional)
    • The column referenced in this field will be displayed when hovering supported data, such as scatter plot points.

Power BI Data Configuration

At this point, the map is nearly ready. However, it still needs Mappedin API credentials to fetch the indoor geometry. From the "Format visual" menu, enter the Client ID, Client Secret, and Venue Slug associated with the venue. These keys must have authorization for GeoJSON Export. Contact a Mappedin representative for details on how to obtain these.

Format Visual

Following these steps, the visual should now be rendered. Any analytics events with latitude and longitude attached will appear overlayed on the 2D map.

Visual Results