xThe Power BI connector for BIMcollab allows you to extract statistical data in order to create fully customizable dashboards for your BIM team.
📝 Note: The connector is currently in the process of being certified by Microsoft to be included as a standard connector with Power BI. In the meantime, it can be used by installing it manually by following the instructions in this article.
Download the Power BI Connector for BIMcollab here
In Windows, copy the BIMcollab.mez file to the following folder:
Documents\Power BI Desktop\Custom Connectors
If the folder does not yet exist then create it
Start Power BI Desktop
Go to File >Options and settings > Options > Security and enable 'Allow any extension to load without validation or warning'
Close Power BI Desktop and start it again
From the home screen, click the 'Get Data' button
Select BIMcollab from the list 'Online Services', or use the search bar to quickly fins the correct connection
Choose 'Connect'
Enter the url of the space you want to connect to and press 'OK'
If this is the first time you are connecting to the space or have not remained logged in, then Power BI will ask you to sign in.
Press the Sign in button to go to the BIMcollab login screen
Fill in your email address and password of your BIMcollab account and press the Login button
The next screen will ask for your consent to allow Power BI to use the BIMcollab API services. Offline Access is required if you want Power BI to be able to refresh data without logging in again. Click 'Yes, allow' to continue.
Once logged in you can click 'Connect' to load the list of projects with their available resources.
Tick the checkboxes of all items you want to use in Power BI and then click 'Load' to start downloading the data.
The available data when connecting Power BI to your BIMcollab space includes:
A. All projects: Activity, Issues and Statistics
B. Space information: Access log
C. Each project: Lists, Activity, Issues
⚠️ Attention: Issue data is available in all plans.
History, or activity and lists are only available in Premium and Ultimate plans.
Statistics and User Access Log are only available in Ultimate plans.
📝 Note: More information about using custom connectors can be found here: https://docs.microsoft.com/en-us/power-bi/desktop-connector-extensibility