SPA (Smart Process Automation) is a tool that allows you to create custom CRM entities and implement various scenarios. Use SPA data in Microsoft Power BI reports. To transfer it, you need to know its unique identifier.

In this article, you will learn how to import data from several SPAs to a Power BI report.

Where to find the SPA ID

Go to CRM > More > Smart Process Automation > Smart Process Automation.

Open the list view settings (⚙️) and select the Type ID field.

In this column, you will see the IDs of each SPA. Copy the ones that need to be added to the report.

How to add SPAs to a report

Go to CRM > Analytics > BI analytics.

Open the Microsoft Power BI tab and install the Universal data source for BI analytics application.
Connect Microsoft Power BI

Open the downloaded file, fill in the connection fields, and click Download.

• Server address and Secret key: Specify the address and secret key of your Bitrix24. You can view information under the BI Analytics > Microsoft Power BI section.
• Smart process ID: Enter the Type ID of your SPA.

Open the Query Editor by clicking the Transform data button.

Open the dataset from crm_dynamic_item and click Duplicate.

Select the copied dataset and open the Advanced Editor.

In the Advanced Editor,

1. Remove this part of the query: #"Smart process ID".
2. Enter the ID of another SPA in quotation marks.
3. Then click Done.

Now, you can use data from two SPAs to create a report. To add more, duplicate the dataset and add the ID of the desired SPA to it.