Clash Report Sample
I’m excited to share an explanation of the #BIM #Coordination workflow using #speckle & #powerbi, This sample focuses on the model status tracking and clash report. I hope this information proves valuable for your projects and inspires you to explore even more creative approaches:
The workflow explanation
If we need a combined visual that is consistently updated with the latest information, let’s follow Speckle guidelines here: https://youtu.be/p81_819vFxo?si=gspc6PDz86fvG_hz
Video for your reference:
BIM Coordination_Speckle_Power BI_Video - Create and share your videos with Clipchamp
Clash Report Sample when we combine 2 branches in 1 visual:
Thank Speckle team for providing a great solution with openBIM orientation.
Great workflow @nikochin ,
Thanks for sharing it with us!
Thanks for sharing @nikochin !
If you have any feedback on how we can make Speckle better, we’re always happy to hear
That’s seems really interesting, can u share the power bi template for more review and asking please?
I am glad to see you guys are interested in this thread
These are materials for your reference:
PBI Clash Report Sample: https://bimmono.com/download/pbi-clash-dashboard-sample
I will try to explain the workflow by following these steps:
1. Clash Detection and Generative the Issue
- Use dynamo for clash detection by Interference Check, Please follow this blog: Dynamo Clash Detection • AECedx
- Then send these Issue elements to “Issue Branch” in Speckle:
The purpose of this process is to create a query including contents like (Element ID of ARC, STR model, Assign this issue to, Comment by coordinator…, and we need a “Mark number” to context multi-element between PBI visuals)
Note: You can replace this step instead of a clash report in an Excel file and then load it to PBI Directly as long as it contains the necessary information like element ID… as I said above.
2. Revit Model files:
- coor_basic_sample_project.rvt : https://bimmono.com/download/revit-coor-sample
(This file is used for clash detection by Interference check → then Generative the Issue (step above) → Then Send “Everything includes Link file” to “Clash Detection Branch”)
- rac_basic_sample_project.rvt: https://bimmono.com/download/revit-arc-sample
(This file is the work-in-progress model by an Architecture consultant, After they fix the clash → The latest model will be sent to “ARC Branch”)
- rst_basic_sample_project.rvt: https://bimmono.com/download/revit-str-sample
(This file is the work-in-progress model by a Structure constant, After they fix the clash → The latest model will be sent to “STR Branch”)
3. Making relationship between the queries in PBI:
Note: We need a “Mark number” to context multi-element between PBI visuals.
So I have tips for automatically filling the “Mark number in the Issue query” to the “Clash Detection Model’s query”:
Let’s use the Merge Queries function in the Power Query, Choose the ID of the clash element that matches with ID in the Clash Detection query to create a new column.
Now you can see, the new column has been filled “Mark number” matches with “Mark number” in the “Issue Query”
Finally, I hope this information proves valuable for your projects, and hope it cuts off unnecessary steps of the BIM Coordination workflow and makes the BIM simple. Thank you for your attention.
This is very helpful, @nikochin! Thank you for sharing the detailed steps with everyone. Keep up the good work!
You helped me a lot through the videos you shared.
Thanks for the kind words ^^!
This is awesome, thank you for sharing.
Hey @nikochin ,
That’s super awesome useful video and explanation.