HEXAGON

How to use Power BI and M.App Enterprise

on - edited on by (3,785 Views)

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

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.

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

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

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.

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:

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

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
...

Rate this article:

Yes No

Comments

Any thoughts on https://community.hexagongeospatial.com/t5/Support-M-App-Enterprise/PowerBI-does-not-show-WMS/td-p/2... ? Thanks Richard

Permalink

I am trying to Login,but getting error 'Could not connect to end point'.I am giving 'https://myserver/' only.

Also url to generate API key will be usefull here.

Permalink

I have the PowerBI account but on trial version for Pro. I don't see any visualization panel as you described above. I'm using the web version. Any ideas?

Thanks.

Permalink

[{"id":"c_27","title":"All tutorials","items":[{"id":"27874","title":"M.App Enterprise - Mobile Documentation","view_href":"/t5/M-App-Enterprise-Tutorials/M-App-Enterprise-Mobile-Documentation/ta-p/27874","isArticle":true,"isUnordered":false,"items":[]},{"id":"27294","title":"How to setup a Mobile App","view_href":"/t5/M-App-Enterprise-Tutorials/How-to-setup-a-Mobile-App/ta-p/27294","isArticle":true,"isUnordered":false,"items":[]},{"id":"26072","title":"Build a Browser App to run a spatial Recipe","view_href":"/t5/M-App-Enterprise-Tutorials/Build-a-Browser-App-to-run-a-spatial-Recipe/ta-p/26072","isArticle":true,"isUnordered":false,"items":[]},{"id":"28016","title":"How to setup a Mobile App - Part 2","view_href":"/t5/M-App-Enterprise-Tutorials/How-to-setup-a-Mobile-App-Part-2/ta-p/28016","isArticle":true,"isUnordered":false,"items":[]},{"id":"29750","title":"M.App Enterprise - Mobile App Beta Testing","view_href":"/t5/M-App-Enterprise-Tutorials/M-App-Enterprise-Mobile-App-Beta-Testing/ta-p/29750","isArticle":true,"isUnordered":false,"items":[]},{"id":"26853","title":"M.App Enterprise 2018 - Hexagon App Launcher","view_href":"/t5/M-App-Enterprise-Tutorials/M-App-Enterprise-2018-Hexagon-App-Launcher/ta-p/26853","isArticle":true,"isUnordered":false,"items":[]},{"id":"33226","title":"Mobile App with tenant metadata and/or data in Oracle database","view_href":"/t5/M-App-Enterprise-Tutorials/Mobile-App-with-tenant-metadata-and-or-data-in-Oracle-database/ta-p/33226","isArticle":true,"isUnordered":false,"items":[]},{"id":"20578","title":"Workflow Tutorial: Creating a Basic Workflow for Desktop App","view_href":"/t5/M-App-Enterprise-Tutorials/Workflow-Tutorial-Creating-a-Basic-Workflow-for-Desktop-App/ta-p/20578","isArticle":true,"isUnordered":false,"items":[]},{"id":"23260","title":"Javascript API in Desktop M.App","view_href":"/t5/M-App-Enterprise-Tutorials/Javascript-API-in-Desktop-M-App/ta-p/23260","isArticle":true,"isUnordered":false,"items":[]},{"id":"34352","title":"Using domain accounts for the Warehouse user","view_href":"/t5/M-App-Enterprise-Tutorials/Using-domain-accounts-for-the-Warehouse-user/ta-p/34352","isArticle":true,"isUnordered":false,"items":[]},{"id":"34056","title":"How to solve Spatial Workshop problems","view_href":"/t5/M-App-Enterprise-Tutorials/How-to-solve-Spatial-Workshop-problems/ta-p/34056","isArticle":true,"isUnordered":false,"items":[]},{"id":"14379","title":"Trainings Materials for M.App Enterprise","view_href":"/t5/M-App-Enterprise-Tutorials/Trainings-Materials-for-M-App-Enterprise/ta-p/14379","isArticle":true,"isUnordered":false,"items":[]},{"id":"28355","title":"Query API samples","view_href":"/t5/M-App-Enterprise-Tutorials/Query-API-samples/ta-p/28355","isArticle":true,"isUnordered":false,"items":[]},{"id":"28400","title":"Support of different Oracle Database Client software versions","view_href":"/t5/M-App-Enterprise-Tutorials/Support-of-different-Oracle-Database-Client-software-versions/ta-p/28400","isArticle":true,"isUnordered":false,"items":[]},{"id":"18999","title":"Apps for the public (no user login)","view_href":"/t5/M-App-Enterprise-Tutorials/Apps-for-the-public-no-user-login/ta-p/18999","isArticle":true,"isUnordered":false,"items":[]},{"id":"34092","title":"Published vectorset not available for use as M.App Enterprise Feature Data in Analyzer View","view_href":"/t5/M-App-Enterprise-Tutorials/Published-vectorset-not-available-for-use-as-M-App-Enterprise/ta-p/34092","isArticle":true,"isUnordered":false,"items":[]},{"id":"17688","title":"How to use Power BI and M.App Enterprise","view_href":"/t5/M-App-Enterprise-Tutorials/How-to-use-Power-BI-and-M-App-Enterprise/ta-p/17688","isArticle":true,"isUnordered":false,"items":[]},{"id":"32966","title":"Working with Tutorial: How to display points thematically in Mobile M.App","view_href":"/t5/M-App-Enterprise-Tutorials/Working-with-Tutorial-How-to-display-points-thematically-in/ta-p/32966","isArticle":true,"isUnordered":false,"items":[]},{"id":"29479","title":"How to add a My Geoservice WMS as a layer in Analyzer Views","view_href":"/t5/M-App-Enterprise-Tutorials/How-to-add-a-My-Geoservice-WMS-as-a-layer-in-Analyzer-Views/ta-p/29479","isArticle":true,"isUnordered":false,"items":[]},{"id":"19004","title":"Standalone Workflow in custom panel","view_href":"/t5/M-App-Enterprise-Tutorials/Standalone-Workflow-in-custom-panel/ta-p/19004","isArticle":true,"isUnordered":false,"items":[]},{"id":"23708","title":"M.App Enterprise Load Balanced","view_href":"/t5/M-App-Enterprise-Tutorials/M-App-Enterprise-Load-Balanced/ta-p/23708","isArticle":true,"isUnordered":false,"items":[]},{"id":"10159","title":"Installation of M.App Enterprise","view_href":"/t5/M-App-Enterprise-Tutorials/Installation-of-M-App-Enterprise/ta-p/10159","isArticle":true,"isUnordered":false,"items":[]},{"id":"17560","title":"How to use Active Directory in M.App Enterprise","view_href":"/t5/M-App-Enterprise-Tutorials/How-to-use-Active-Directory-in-M-App-Enterprise/ta-p/17560","isArticle":true,"isUnordered":false,"items":[]},{"id":"22573","title":"How to: Display thematic legend entry in Desktop M.Apps","view_href":"/t5/M-App-Enterprise-Tutorials/How-to-Display-thematic-legend-entry-in-Desktop-M-Apps/ta-p/22573","isArticle":true,"isUnordered":false,"items":[]},{"id":"29473","title":"Desktop Client Log Console (F12)","view_href":"/t5/M-App-Enterprise-Tutorials/Desktop-Client-Log-Console-F12/ta-p/29473","isArticle":true,"isUnordered":false,"items":[]}],"isUnordered":false}]

Overview

M.App Enterprise Tutorials