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 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 ...
    • Test Drive MobileMMS

      With our map-based interface and flexible form builder and workflow management configuration there is no limit to the customers that can use our MobileMMS product. Click here to take a test drive of MobileMMS WASTEWATER UTILITY Line Cleaning Manhole ...
    • 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 ...