Connecting to Other Data Sources

ASM can connect to Power BI or other data sources to manage your reporting requirements.

Beginning with ASM Version 10, embedded Dashboarding and Reporting functionality was provided through the Syncfusion Dashboard Platform. Alemba used the latest version of the Syncfusion Dashboard Platform v4.1.0.84 under a Global Embedded License with Syncfusion. Support for this platform ended December 2024.

From September 2022, the Syncfusion Dashboard Platform entered the Extended Support phase of its product lifecycle until the end of September 2024. As Alemba is a Premium Support partner with Syncfusion, this was extended until the end of December 2024.

As of December 2024 (10.6.8.15038), ASM Supports connections to Bold BI natively for Analytics.

Create the Data Query in the ASM API Explorer

The first step is to create data query the ASM API explorer. Use this guidance to login.

  1. Select the entity (call request, task, etc.)

  2. Select the search function. You need to fill out the fields you need in the red area below in comma separated format and it will give you a URL in the green area. Use the list on the right hand side of the screen to get the field names.

If anything returns a number instead of a value, enter .Name to the end to get the value of it rather than its primary key value.

Configure Power BI

PowerBI expertise is needed for this section. Alemba can only give general advice.

  1. From the Get Data Menu, Select "Web"

  2. Enter the URL you have from the API explorer

  3. Enter the account credentials that you created earlier

  4. In the PowerQuery editor you can transform the data to a table.

  1. You may need to expand some columns, specifically where the value is a reference to a list or object (e.g. a drop down, person, CI, service, etc.). In the pop out menu, select Name to get the value. Repeat this for each column.

You can also follow a similar process in Excel or other data sources.

Last updated

Was this helpful?