Hexagon Geospatial
MENU

M.App Enterprise Tutorials

Not sure on how to get started or looking for a workflow to get M.App Enterprise up and running. Tutorials provide step by instruction on some of the most common configurations and workflows to get M.App Enterprise configured up and running quickly.
Showing results for 
Search instead for 
Do you mean 

How to use Power BI and M.App Enterprise

by Technical Evangelist on ‎11-16-2017 04:56 AM - edited on ‎12-18-2018 02:08 AM by Technical Evangelist (1,375 Views)

This tutorial describes how you can combine M.App Enterprise and Power BI. 

 

 

Note: With 16.1 SP2 the widget only works based on API - Keys. If you have an older version of M.App Enterprise please use version 0.9.3.

 

 

How to get the custom widget into Power BI

 

1.) Log in to your Power BI account at https://app.powerbi.com

2.) Click in the Visualization panel on the three horizontal points.

import.png

3.) Click Import from file

4.) Point to the *.pbiviz file (you have to download and extract the attached file first)

5.) Now you should see the Hexagon Geospatial Logo

hexlogo.png

 

 

How to use M.App Enterprise in Power BI

 

1.) Click on the Hexagon Geospatial Logo

2.) A widget placeholder gets visible in the main window

3.) Drag and drop the desired columns from the data to the corresponding Fields of Power BI.

 

Note: You have the possibility to either set Latitude / Longitude or WKT Geometry. It is not possible to use both approaches. The columns Latitude / Longitude need not to be in geographic coordinates.

Latitude = phi or y

Longitude = lambda or x 

 

4.) As soon as you dropped a column in the corresponding field, the widget in the main window changes and you now can connect to certain Map Views, which were created in M.App Enterprise Studio.

 

 

M.App Viewer widget 

 

 

widget.png

 

 

 

Login:

Tenant: Name of the tenant, where the Map View is available

M.App Enterprise Endpoint: URL to the Server (e.g.: https://myServer/)

 

API-Key: You have to use one of the API-Keys, you have created in the Studio. For more information on how to create API-Keys please have a look at the FluidTopics help.

 

NOTE: If you are using version 0.9.3 of the Power BI widget you have to use 

Username and Password of the Studio administrator to login successfully.

 

 

mapconfig_mae.png

Map Configs:

 

Map Config: All available Map Views in the previous defined Tenant.

Map SRID: Shows you the SRID of the Map View.

Geometry SRID: This is only needed if the SRID of the geometry is different to the SRID of the map.

 

Note: As soon as you have changed the Map Config and set the Geometry SRID correct, click Reload.

 

 

 

legend_mae.png

Legend:

Here you can switch on / switch off layers, which should appear in the Map widget. 

 

 

symbols_mae.png

Size: Can be static or if the Field is correctly set also be dynamic

Color: Can be static or if the Field is correctly set also be dynamic

 

 

 

Aggregate Function in Power BI widget (With version 2.0.0)

 

In databases an aggregate function or aggregation function is a function where the values of multiple rows are grouped together to form a single summary value for example:

 

  • Count
  • Average
  • Maximum
  • Minimum
  • Sum
  • ...

 

 

 

 

Comments
by
on ‎04-13-2018 06:47 AM
Overview