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.

Select the entity (call request, task, etc.)
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.

From the Get Data Menu, Select "Web"
Enter the URL you have from the API explorer
Enter the account credentials that you created earlier
In the PowerQuery editor you can transform the data to a table.

You may want to edit the query at this point and add &$top=99999 to the end of the query (change the number as appropriate). By default, Power BI will only return 1000 results. Be cautious of the limit and trying to drag too many columns along with a large row limit at once. The more data, the slower the query. Unfortunately there’s no exact science on this, it’s trial and error due to the number of variables involved.
You want to avoid using long text fields like the description because those fields can be incredibly large.
You also want to optimise your selection to only request the data that you need so it performs well. I.E. make sure you only select columns you need and add appropriate filters so not too many results are returned.

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.

PreviousDashboards and Reports (.sydx Files)NextSample SQL Queries

Last updated 1 month ago

Was this helpful?

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.

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

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.

From the Get Data Menu, Select "Web"

Enter the URL you have from the API explorer

Enter the account credentials that you created earlier

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

You may want to edit the query at this point and add &$top=99999 to the end of the query (change the number as appropriate). By default, Power BI will only return 1000 results. Be cautious of the limit and trying to drag too many columns along with a large row limit at once. The more data, the slower the query. Unfortunately there’s no exact science on this, it’s trial and error due to the number of variables involved.
You want to avoid using long text fields like the description because those fields can be incredibly large.
You also want to optimise your selection to only request the data that you need so it performs well. I.E. make sure you only select columns you need and add appropriate filters so not too many results are returned.

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.