Power BI

Willem_Creffier · February 4, 2019, 11:02pm

Hi there

I see some interesting copy on the link between Revit, through Dynamo to Power BI.

I would like to make an archive of realized projects, by making a model on a functional level of detail (masses rather than rooms), and asses them on a number of characteristics.
Simultaneously I want to do the same with the cost information I get from the offers.

Power Bi looks an appealing platform to start gathering and visualizing this data.

Has anyone done this before, and are you willing to share this with me?

A project with the according Dynamo Script and BI file.

Or can I find a tutorial or a self-training program on this?

Kind regards,

Willem

Dave_Curran · February 6, 2019, 5:17am

Willem,

Check out Ryan Cameron’s website Architect Machines, he has a couple scripts that you can download and mess around with. I also found the Lynda.com’s basic Power BI tutorials pretty helpful. Hope this helps. Cheers.

http://architectmachines.com/

Willem_Creffier · February 6, 2019, 9:04am

Oh, perfect.

I did see some video’s about RC’s practice , but didn’t find his website.

I am older than twelve tough.

This will get me started, thank you Dave.

adam_bear1 · February 6, 2019, 10:02am

I once wrote a longinsh python script that inputs a navisworks XML to locate 3d clash points outputing a 2d svg plan (made from revit rooms). Synoptic addin for SVG in power bi is then a powerful tool for drilling down data. This then has uses for clash auditing that is commonly done in excel but could be improved as a dashboard. It would be a bit of work to change the rooms to masses but if take a look at @Jeremy_Graham’s python courses at lynda that should get you going.

github.com

Amoursol/dynamoPython/blob/f617259bb360f09c24a3a1f3e73b4914b864e51a/revitAPI/xmlSvgExporter.py

'''
CLASH SVG EXPORTER - EXPORT NAVISWORKS CLASHES FROM XML TO SVG
-
a dynamoPython script, visit the website for more details
https://github.com/Amoursol/dynamoPython
'''
__author__ = 'Adam Bear - adam@ukbear.com'
__twitter__ = '@adambear82'
__github__ = '@adambear82'
__version__ = '1.0.0'

'''
for large projects with lots of clash data it is useful to analyse in
a business inteligence or data visualisation tool such as ms power bi.
exporting clashes from navisworks to an xml file provides a useful
format to extract data from. Ensure clashpoint and distance are
exported to the xml report, otherwise index lookups in code will need
to be adjusted. This script exports a svg file of circles at points
here clashes occur, and polygons where room boundaries are found to
give a context.

This file has been truncated. show original

Willem_Creffier · February 21, 2019, 9:42pm

Thank you, Adam Bear.

Altough I have to admit this is beyond my capacity to comprehend.

I will start with the visual stuff, and when I have all my scheme’s ready I will ask someone to take it to the next level.

Regards,

Willem.

allan.cantos · October 9, 2020, 3:53pm

Hope this helps: https://www.youtube.com/watch?v=BQH0EdGtjOQ&t=102s

RubenVivancos · February 10, 2021, 2:41pm

hello Adam, I am really interested in that. How is the SVG represented? is it a 2D view of rooms or something else like elements placed on the clash points of the navisworks test?

Thanks in advance.

truevis · May 21, 2021, 9:58am

It looks like Proving Ground has developed commercial apps for Revit > Power BI.

Video: Business Intelligence for Architecture, Engineering, and Construction (Recording Live on May 20) - YouTube

Topic		Replies	Views
AU 2018, submission accepted, it's about data visualization, please check it out :) Revit dynamo	9	762	November 4, 2019
Export boundaries of Revit Rooms to SVG, and use them in PowerBi Revit	54	8948	October 25, 2021
Export room boundaries to SVG (units issue?) Revit	1	1053	August 4, 2020
Python for Model information extraction for Power BI Dashboard Revit python	4	1240	March 7, 2021
Working with Revit in Excel as in Dynamo. Asking for feedback Revit revit , excel , python , ifc , export	17	530	March 18, 2024

Power BI

Related Topics