WOW! I’ve been struggling for a while trying to find a good way to learn BI and this video makes it so easy. Love this! Can’t wait to get back into the office to start creating some dashboards! Thanks, Jeff
Regarding the multi category schedules You could NWC it out into navis works then export the schedule as one excel file (within navis works takeoff). It’s not live but saving quantities with revision history has its perks when recalling cost changes.
For whoever is trying to recreate the dynamo script, please read his note where it says: "REMEMBER TO CHANGE LACING TO CROSS PRODUCT" My head is frying, after spending alsmot 2 hours trying to figure out what I was doing wrong Thank you very very much for this video.
@@TheRevitKid Jesus Christ, I couldn't believe when I read your note!! hahaha. Thanks a mill! I've been working with PowerBI and Plant3D for quite a while but never with Revit. Now we're starting a new project where both programs will have to be used. Thanks to your script, I'll be able to integrate Revit into my dashboards.
You can make a multi-category schedule which includes all the element categories in one schedule without missing anything if you are making structural plans. You just have to do a material takeoff schedule. I have done it for numerous projects and it works. Didn't need to touch dynamo or anything else . Just Revit.
Any chance you will consider diving into more of the Power BI dashboards? I'd love to see your process from your actual VDC work and see the entire workflow of how you create and format your excel sheets and how you build those sweet dashboards. I work for a small midwest GC as a VDC manager and would love to start implementing this type of thing to assist our preconstruction team on bids. We have a bunch of existing excel spreadsheets but they are not formatted to be easily used in Power BI. I would love to see you take one of your old excel sheets you mentioned and show us the process of how you took it into BI and then how you would do it now that you know BI.
I'll do an updated one soon... but, for now, here is an older one with some good stuff: therevitkid.blogspot.com/2017/09/did-you-miss-assemble-webinar-last-week.html
Power BI will also live connect to Revit projects on BIM360, no need to export anything, AND you have access to EVERYTHING all at once in the entire project database.
I have got it to work successfully with the forge web hooks and power BI data link. Was quite easy once I understood webhooks and how it’s authenticated to allow power bi to pull the data. Il have a look and see if it could work directly with bim360 now seeing as it’s always changing.
The file menu is slow because revit is going through the "recent documents" list and it can't find one for whatever reason (deleted, changed location or some server that you're not connected to). It has x amount of tries it performs and it takes time. To avoid that, just clear the recent documents list. C:/users/[username]/AppData/Roaming/Autodesk/Revit/Revit{version}/Revit.ini open with text document editor. At the bottom there is section [Recent File List] File 1= path to the file, File 2 = path to the file.... Delete them. Just don't delete the parameter, which is "[Recent File List]" Thanks for the video! :)
Wanted to thank you for your video and just to let you know, I totally stole your dynamo script and did my own excercise connecting my revit data to power bi! Now if only I could manage to do the same with project online, then I would have a really powerful report tu show :)
@@TheRevitKid Thanks for sharing Dynamo script. I grabbed it too. it was my first foray into Dynamo! it worked great except I cant get SF, LF, EA to populate in Takeoff unit column. If anyone has advice on how to resolve that would be greatly appreciated. on the Power Bi side can you please copy/paste DAX code here exactly how you entered it not how it was recorded, to create TOTAL COST column. I'm struggling with where to write if, ( , then, etc hahahaha. Dynamo visual coding is so much easier!!!
Can you pls make a video on how to import 3D view of revit into power BI and create a dashboard of material qty? It would great help if you can do that, Thanks.
@@bimobject_ben5718 Oh! That is from a company called "Case, Inc" ... They were acquired by WeWork back in 2015-ish... Sorry, not sure you can get them anymore!
Thanks for the comment and for watching! These videos are live streams so they are a bit longer... I have begun breaking them down into shorts and smaller videos... Hopefully the chapters help you get through them!?