In this article:

• Send a BI Connector request in a browser
• Send a BI Connector request in Postman
• Test queries before you create a report

Send a BI Connector request in a browser

Use the following URL:

https://account_name.bitrix24.com/bitrix/tools/biconnector/pbi.php?token=key_bi-connector&table=crm_deal

1. Replace account_name with your Bitrix24 account name.
2. To view data in Microsoft Power BI, use pbi.php.
   For Looker Studio (formerly Google Data Studio), use gds.php?data&.
3. Add your token from Analytics > BI Analytics > Key Management.
4. Add the entity you want to retrieve data from.
   In this example, we use crm_deal, which returns the list of deals.

After you run the request, Bitrix24 returns all entity fields and their values from your account. This helps you check which fields are available and what data they contain.

Send a BI Connector request in Postman

Large responses can be hard to review in a browser. We recommend using Postman instead.

To create a request:

1. Click Create new collection > Add a request.
2. Select the POST method.
3. Enter the request URL:

https://account_name.bitrix24.com/bitrix/tools/biconnector/pbi.php?table=crm_deal

4. Add the key to the request body.
5. Click Send.

Postman shows how long the request takes and what data it returns.

Test queries before you create a report

Before you create a report or load data from leads, deals, or custom fields, test your queries in Postman.

For example, a monthly deals report may return a large amount of unnecessary data. Add filters to reduce the dataset and improve report performance.

If you need specific fields and want to filter deals by creation date, use the following request:

 { "dateRange": { "startDate": "2023-03-22", "endDate": "2023-03-23" }, "configParams": { "timeFilterColumn": "DATE_CREATE" }, "fields": [ { "name": "ID" }, { "name": "DATE_CREATE" }, { "name": "DATE_MODIFY" } ] } 

Parameter description:

• dateRange sets the date range.
• configParams uses the DATE_CREATE field to filter deals by creation date.
• fields defines which fields to return.

In this example, the request returns:

• Deal ID
• Creation date
• Modification date

Run the request and review the results. Update the query if needed.

To limit the returned data, add the dimentionsFilters parameter.

 { "dimensionsFilters": [ [ { "fieldName": "ID", "values": [581, 601], "type": "INCLUDE", "operator": "EQUALS" } ] ] }