Using PowerBI with MobileMMS Rest API

Using PowerBI with MobileMMS Rest API

In order to analyze MobileMMS Data in Microsoft PowerBI, you must add data source using the following procedure:

  1. In order to connect to the MobileMMS API in Microsoft PowerBI using the Get Data From Web option, you must first create an API key within MobileMMS.

  1. To generate the key, access your MobileMMS user profile and go to the API Keys tab.
  2. Then Select the "Add API Key" option
  3. You will be prompted to provide a name for the Key and then you will be provided with the key.
  4. You can select the copy button to copy it your computers' clipboard so it can be used in PowerBI.

In Power BI, select Get data -> From Web -> Advanced and provide the data URL in parts or as a whole.  

You will need to repeat this process for each form that needs to be retrieved from the MobileMMS API.

  1. /Forms/{FormId}/FormRecords/View
  2. ?includeFormFieldListItems=true
  3. &includeFormFieldOrganizationUserListItems=true
  4. Add an HTTP request Header called "Authorization" and then "Key {Token}" where the token is what was created above.

Once the data is retrieved, it will look like a table that can be used to create the PowerBI.

Here is an example of a simple bar chart:


    • Related Articles

    • How to use the MobileMMS API Search Endpoint

      How to use the MobileMMS API Search Endpoint The search endpoint can be used to search a MobileMMS form with everything from a very simple query all the way to a very elaborate nested query. The basics of the JSON to search various data types of a ...
    • How to use Low Data Mode to delay uploading photos in MobileMMS

      If you are using MobileMMS with a connected device like a tablet or laptop but your connection speeds are slow, you can use our Low Data Mode option to delay uploading of the pictures or attachments you may be taking while creating or editing ...
    • Crystal Reports

      Building Crystal Reports in MobileMMS One of many ways of summarizing and displaying information in MobileMMS is to build Crystal Reports.  Crystal Reports have the advantage of allowing the designer to format and summarize the data to a desired ...
    • How to Print a record with a basic layout.

      Any user can print the basic layout of a record by using the print below.  Once selected, a new tab displaying the record with the basic layout will be shown and the the user can then use the browsers print function to print the record to the desired ...