In this article we will explain how you can link the Catenda HUB database with PowerBI.
By linking you have direct access to the data on Catenda HUB in PowerBI. This data can then be used to evaluate tasks, documents or, for example, team members.
To begin with, you will need the following installation package in addition to PowerBI.
Once you have installed both, you only need to create a connection from PowerBI to the Catenda HUB database. To do this, proceed as follows:
Open PowerBI and click on "Get data from another source".
Select the target source under Other --> Bimsync. In the course of the rebrand, the old name Bimsync is still available, but will be changed to Catenda over time.
Use "Connect" to establish the connection to the database.
A navigator opens in which all projects you have access to are listed. Select the corresponding project and the table to be linked. In our example we would like to evaluate issues in PowerBI. Click on "Load" to load the dataset.
Here you will be able to choose from the following datasets:
PowerBI now loads all the data for issues and displays it on the right-hand side.
Select the appropriate data field and create your analysis.
Depending on what data is present in your project and what data you load, different relations will be made automatically.
Here is a map of what the connections look like when all information is present in your project and you have loaded all project data: