Connect Microsoft Power BI with BIMcollab Cloud

  by Ruby Marijt  - BIMcollab Content marketer,  March, 2019  

Microsoft Power BI is a free business intelligence tool that provides users the possibility to  analyze, visualize and share data. Power BI's user interface is intuitive for users and is familiar with Excel. The new Power BI connector for BIMcollab Cloud is very easy to set up and extracts statistical data from the BIMcollab issue management system to create insightful reports and dashboards. 

Connect to Power BI in seconds, without coding!

The connector makes it easy to connect without any coding. So, you can start in-depth analyzing your BIMcollab data in seconds. The only thing you need is a private BIMcollab Cloud and the free connector, which can be downloaded here.


Creating a Power BI connection

Here is how you connect the Microsoft Power BI with BIMcollab Cloud in just a few simple steps:

Step 1

Copy the BIMcollab.mez file to the following Windows folder: Documents\Power BI Desktop\Custom Connectors


Step 2

Start Power BI Desktop and 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.



Step 3

From the home screen you can now click the Get Data button in Power BI Desktop and look under Online Services. Select "BIMcollab (Beta)" and press the Connect button to continue and fill in your BIMcollab cloud url.

Note: Until the connector is certified by Microsoft the connector is marked a Beta. More information about using custom connectors can be found here.


Step 4

Press the Sign in button to go to the BIMcollab login screen and fill in your e-mail address and password of your BIMcollab account and press the Log in button. This allows Power BI to use the BIMcollab API services.


That's it!

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.