Get Dashboard Data results from BIMcollab Zoom in Power BI.
With the Lists feature in BIMcollab Zoom, you have the option to choose the type Dashboard Data. This Dashboard Data is usable in Power BI.
BIMcollab Zoom
Open the BIMcollab app with an active license and connect to the preferred space and project
Go to the Lists panel
Select a List set in 'Shared', or create a new List set
Create a List of the type Dashboard Data.
For more information on creating Lists, consult the article Setup Lists in BIMcollab Zoom.Double-click on the List to show the results, and make sure the Active Model results are active
Hit the 'Share results' button.
The Dashboard Data is now synchronized to BIMcollab.
📝 Note: Dashboard Data cannot be viewed in BIMcollab. These results are meant to be used in Dashboard software like Power BI.
⚠️ Attention: This feature is not available on all plans. To check if it’s included in your subscription, review the [plan comparison list] or contact your admin. If the feature isn’t available, you may need to upgrade your plan.
Power BI (desktop)
For more information on the installation and use of the connection between BIMcollab and Power BI, consult the article Installation Guide for Power BI connector.
When the connector has been installed, you can follow these steps to set up a dashboard from the List data.
Open Power BI (desktop)
Click the 'Get data' button from the home screen
Select BIMcollab from the list 'Online Services', or use the search bar to quickly find 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, Power BI will ask you to sign in. Press the Sign in button. You will be redirected to the BIMcollab login screen
Sign in with your credentials for the BIMcollab space
Give Power BI permission to connect to BIMcollab by clicking 'Yes, allow' in the next screen
After having logged in, you will be redirected to Power BI. Click 'Connect'
In the Navigator, you will get an overview of the projects in the space to which you connected. Navigate to the correct project, select the List you want to load in Power BI, and click 'Load'
Go to the window 'Fields' and check the boxes of the fields you want to show in the dashboard
⚠️ Attention: Only properties that have been added to the List in BIMcollab Zoom will be shown here
Choose the preferred Visualizations and Filters
For example, if you only want to view the data from one model, drag the 'Summary, Model' property into the filter view, and select the model for which you want to visualize the data.
Update the results
BIMcollab Zoom
When a model has been updated, added, or removed from BIMcollab Zoom, the data on the Power BI dashboard can be updated according to the new situation.
Update the models in BIMcollab
Go to the Lists panel
Right-click on the preferred dashboard data list and choose 'Run'.
The data will be updated
Hit the 'Share results' button
The results will be synchronized to your BIMcollab project
Power BI (desktop)
Go back to Power BI
Open the associated dashboard and make sure you are connected to the correct BIMcollab space
Press the 'Refresh' button on the home screen
The updated data will be loaded.
📝 Note: In Power BI Pro, the updating can be set to happen automatically according to a schedule.
⚠️ Attention: If the Lists don't show up in Power BI, make sure the following is correct:
The latest version of the Power BI connector is installed. The Lists Feature isn't available in earlier versions of the connector.
The type of List you synchronize from BIMcollab Zoom is Dashboard Data.