What is the best way to implement getting data in power bi from bitrix24?

Question

API

Hello, I have such a task. At work, I need to build reports in power bi based on data from Bitrix and so that this data is constantly updated. Various Bitrix integrators with power bi are no longer available. It remains only with the help of requests to extract data. But what is the best way to implement this. Maybe someone has already solved this issue?

Answer 1

Bitrix gives access to its data through the API:
https://dev.1c-bitrix.ru/rest_help/rest_sum/start.php
https://training.bitrix24.com/rest_help/rest_sum/s...
But it is adequate through it building analytics will not work, you need some kind of intermediate storage.
The most adequate option, kmk, is to make a new application that will periodically pull data from Bitrix and put it into some kind of database, for example, clickhouse or postgresql.
And then on the side of powerbi, using DirectQuery to build reports.