1. Download this template
2. Open the file you just uploaded.
3. Go to Data Tab, click New Query and pick Launch Query Editor
4. In the Query Editor window click Manage Parameters-Edit Parameters on the Home tab.
5. Copy your token from the application Power BI Integration from your Bitrix24 portal (see "Get started" tab) and insert it to the pop-up window Enter Parameters, then click OK.
6. Run the refresh data process (you will get data from your Bitrix24 portal using your token)
You can set an auto-update in Excel.
7. Manage relationships between the data models here (Data-Relationships)