How to convert DB to readable select in Power BI?

Question

MySQL

Good afternoon!

Please tell me in solving this problem:

There is Bitrix24 (box) - and the MybiConnect service - the Power BI program.
Uploading data from MybiConnect to Power BI is already clear to the user (the columns are in Russian, unnecessary data has been removed, and so on), but the service does not provide all the information that is needed. And I thought about setting up uploading data directly to Power BI from Bitrix24 (I set up a tunnel, since a direct connection to Power BI is not given), I get the data, but they are the same as in the database.

How to make data acquisition similar to MybiConnect (I understand that I need to edit the data), how to make it work and in the future I can reconnect and do not have to do the same work of editing data from the database?

The MybiConnect service acts as a connector - it receives data from B24, converts it into a readable/correct format, and sends it to Power BI.

Answer 1

You can use a webhook if it is cloudy or take data directly from objects using the functions of the D7 framework if it is a box and insert it into datasets for powerbi https://docs.microsoft.com/en-us/power-bi/develope...
if directly from the database then you can do view https://dev.mysql.com/doc/refman/8.0/en/create-vie...