- To integrate Assemble with Power BI, the team needed to locate a 3D building model that met the necessary criteria and was modeled with the correct attributes. Fortunately, we were able to find a suitable structural model that featured a concrete foundation and steel structure, making it a perfect fit for our needs.
- Once we published the model in stanford.tryassemble.com, we created a specific sheet to link to PowerBi. We created a new column to show installed vs not installed elements. Being able to change the properties, and add custom columns makes us believe there are a lot of ways we can improve our project and planning control system and we will explore these options in the upcoming weeks.
- Below is a picture of the model. In green are the elements that have been installed and in red are the elements to be installed in the future.
- To integrate Assemble with Power BI, we first have to go to the "Home" tab and click "Get Data. Select "Online Services", then select “Assemble Views” from the list of data sources and click "Connect."
- Enter the URL for your Assemble project and click "OK." Power BI will connect to your Assemble project and display a list of available tables. In the Navigator dialog box, select the Assemble Views that you want to load. For each project, there's a single item for view images named [Your Project] View Thumbnails. Select this option if you want to include images in your report. Select Transform Data to continue to Power Query.
- In Power Query, you'll see a single column named Rows. On the header of the column, select the button with two arrows pointing in opposite directions to expand your rows.
- Uncheck Use original column name as prefix and select OK for each view data query you've selected. Select Close and apply to load the data sets.
- To keep your Power BI report up to date with changes in Assemble, you can set up automatic data refresh. Go to the "File" tab, click "Options and settings," and select "Data source settings." Select your Assemble data source and click "Edit." In the "Data source settings" dialog box, select "Enable Load" and "Enable refresh." Set the refresh schedule and click "OK."
For next week’s goal, the team would like to explore more adding custom columns to improve our project and planning control system. Once the base case is complete, we will proceed to start learning how to create charts and KPIs in PowerBi