With the Power BI connector for COMMITLY, you can extract data from COMMITLY to build fully customizable dashboards for your BIM team within your Microsoft environment.
Note: The connector is currently being certified by Microsoft so that it can be included as a standard connector in Power BI. In the meantime, you can install it manually by following the instructions in this article.
Prerequisites
Power BI Desktop
Access and credentials for the COMMITLY API
Installing the COMMITLY Power BI connector (Power BI Desktop)
Note: The COMMITLY Power BI connector is (currently) an uncertified custom connector
Download the COMMITLY Power BI connector here
Copy the connector's MEZ file (CommitlyConnector.mez) to your local folder [Documents]\Power BI Desktop\Custom Connectors. If the folder does not exist, create it.
To adjust the data extension security settings, in Power BI Desktop select File > Options and settings > Options > Security.
Under Data Extensions, select (not recommended) Allow any extension to load without validation or warning.
Select OK and restart Power BI Desktop.
Upgrading the COMMITLY Power BI connector version or changing credentials (Power BI Desktop)
If the connector version is updated or the COMMITLY API credentials are changed, additional steps are required to clear the cache.
To clear the global cache, in Power BI Desktop select File > Options and settings > Options > Data Load.
Under Data Cache Management Options, select Clear Cache.
Select OK.
To clear the cached credential settings, in Power BI Desktop select File > Options and settings > Data source settings.
Under Global permissions, select COMMITLY API [Client Credentials].
Select Clear Permissions.
Select Close.
How to get data from a COMMITLY connector data table in a Power BI report (Power BI Desktop)
Create a new blank report.
Select Get Data and select More...
In the Get Data window that opens, search for the COMMITLY Connector (Custom) and select it.
Select Connect.
Enter the COMMITLY API credentials (Client ID and Client Secret) and select Connect.
Retrieve the API credentials (ID / key) under:
ADD-ONS > Activate Direct API
After activation, the Client ID and Client Secret are displayed.
Select a table from the COMMITLY connector sources and define a name for a query.
Finish the query by selecting Close & Apply.
The queried table is available for data analysis in Power BI.
Additional steps for installing the COMMITLY Power BI connector (Power BI Service)
Note: The COMMITLY Power BI connector is (currently) an uncertified custom connector.
To make the COMMITLY Power BI connector available in Power BI Service, an additional installation of Microsoft's On-premises Data Gateway service is required.
After the COMMITLY Power BI connector is installed and configured in the On-premises Data Gateway, it will be available in the data source settings in Power BI Service workspaces.
Useful articles: