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.
@agradoville4 жыл бұрын
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
@kaisimon98943 жыл бұрын
instablaster.
@cansuyeni3 жыл бұрын
It is such a helpful tutorial. It is perfectly clear and understandable. Thank you for this great job!
@BillDebevc4 жыл бұрын
Thank you for this great tutorial. It got me thinking of how to use Power BI
@TheRevitKid4 жыл бұрын
Bill Debevc - cheers bill! I hope all is well man!
@alexreeves40092 жыл бұрын
Great video! Would love to see a deep dive on power BI dashboards for construction estimating and VDC practices!
@TheRevitKid2 жыл бұрын
Glad you enjoyed! I could go on for hours about the dashboards we use and create... I'll note it as a topic in the future.
@RSBKCLIPS Жыл бұрын
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 Жыл бұрын
hahaha I am glad you finally figured out! List Lacing is one of those things in Dynamo that could DRIVE YOU NUts.. but also MAKE YOUR DAY! Cheers!!!
@RSBKCLIPS Жыл бұрын
@@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.
@TheRevitKid Жыл бұрын
@@RSBKCLIPS Very cool! Good luck man!
@MiralMahran Жыл бұрын
Thank you for sharing your thoughts. Loved this Tutorial 👏
@TheRevitKid Жыл бұрын
Cheers! Glad you enjoyed. Thanks for tuning in
@fukuda60253 жыл бұрын
That's amazing.. still learning dynamo to understand fully that code, but definitely showed us a way to approach 5D BIM
@TheRevitKid3 жыл бұрын
Glad it was helpful!
@alenjertec68512 жыл бұрын
This is awsome video. Thanks TheRevitKid! Really appreciate it. :D
@TheRevitKid2 жыл бұрын
Cheers! Glad you enjoyed !
@macoveialex68233 жыл бұрын
Min 50:00 is what I was looking for.
@thiagonieves43574 жыл бұрын
You´re the man! Great job! I´m very eager to try that Revit Power BI integration.
@agradoville4 жыл бұрын
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.
@TheRevitKid4 жыл бұрын
I'll add it to the list of topics. ;)
@48VAC4 жыл бұрын
Great video. I don't get a chance to watch live.
@marv.innovations802 Жыл бұрын
I love it, Kudos to you and thanks a million.
@TheRevitKid Жыл бұрын
Cheers!!! Thanks for tuning in
@kittyblossom73423 ай бұрын
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.
@ryanrazer12 жыл бұрын
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! :)
@TheRevitKid2 жыл бұрын
Ryan, thanks for the advise! I hope it helps some!
@zebastianberglundolsson57233 жыл бұрын
I would love to see a video about Assemble!
@TheRevitKid3 жыл бұрын
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
@zebastianberglundolsson57233 жыл бұрын
@@TheRevitKid Awesome! Really appreciate the content you are creating! :)
@maxipaxi6338 Жыл бұрын
This nice!! More information about this theme on the site?
@sai7422 жыл бұрын
46:00 i think revit 2022 can create a multi category schedule
@memyadventures27303 жыл бұрын
You are an amazing person 👏🏻❤️
@maroofjamal5752 ай бұрын
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.
@TheRevitKid2 ай бұрын
Um... that is exactly what this video is.....?
@tatianabedregalflores45904 жыл бұрын
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 :)
@TheRevitKid4 жыл бұрын
Tatiana Bedregal Flores - you didn’t steal anything!! I share it so you do exactly that !!! So awesome !!!
@anaele1976 Жыл бұрын
@@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!!!
@RSBKCLIPS Жыл бұрын
Damn, I don't know what I'm doing wrong but my dynamo won't run properly...
@johngray24594 жыл бұрын
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.
@TheRevitKid4 жыл бұрын
I could be wrong... but, this requires connection with Forge, no?
@M0JHN3 жыл бұрын
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.
@fam80263 жыл бұрын
Access is the solution
@bimobject_ben57183 жыл бұрын
Thanks for sharing! Really nice run-through. I love that T you have on in the video, where can I get one?
@TheRevitKid3 жыл бұрын
Thanks man! What do you mean by “T”?
@bimobject_ben57183 жыл бұрын
@@TheRevitKid sorry your t shirt.
@TheRevitKid3 жыл бұрын
@@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!
@devadarshanbhadra Жыл бұрын
please upload the scheduled dataset so that can be practiced in powe-bi
@user-ef5tl8bh8b9 ай бұрын
I click randomly of these 4 to enter schedule properties! Never click right lol.
@TheRevitKid9 ай бұрын
😂
@user-kv1fy3vp7x3 жыл бұрын
Hi, great video! Thx Is it any colored filter for all color dim ant text ?
@TheRevitKid3 жыл бұрын
It's part of my template...
@DesignsbyCADPRO4 жыл бұрын
interesting way to use Revit... :)
@pavillon93653 жыл бұрын
Hi, That is incredibly interesting. Do you have a video that show us how to actually build that script? i am not Dynamo expert.
@pavillon93652 жыл бұрын
EDIT: In Revit 2021 System Families are included in MultiCategoty Schedule
@kfl37003 жыл бұрын
I learned alot from your video. In Dynamo, is there a way to extract Type parameters rather than Instance parameters?
@TheRevitKid3 жыл бұрын
Yes, same process!
@ashokshrestha211910 ай бұрын
Will there be more updates video related to power bi and Revit Link up
@TheRevitKid10 ай бұрын
The process from Revit to BI hasn’t changed much … other than the introduction of Tracer from proving grounds …
@netblingers63068 ай бұрын
I am watching this video, is the dynamo still required in 2023 for multi category schedule, or do we have built in options in revit 2022/2023
@TheRevitKid8 ай бұрын
Still required if the multi category schedule doesn’t do what you need … but yes, 2024 and 2023 have more system family options for multi category
@thomasroyle31963 жыл бұрын
In Power BI how have you got the Count of family Type Column?
@TheRevitKid3 жыл бұрын
It comes from the data .... Pretty simple to get counts in Power BI
@muneebafzal1852 жыл бұрын
Based!
@vemareddydareddy72782 жыл бұрын
Please do the videos short length
@TheRevitKid2 жыл бұрын
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!?
@vemareddydareddy72782 жыл бұрын
@@TheRevitKid , Thanks for the response, You would have to include video for 3D images loading into Powerbi.
@leandroreati6422 жыл бұрын
Nice shirt :)
@danielkrajnik38173 жыл бұрын
*revit to txt to power BI. A bit disappointed. Dunno why expected power bi to speak directly to revit. back to python it is
@TheRevitKid3 жыл бұрын
Tune into the channel tomorrow at 1230 EST ... ;)
@danielkrajnik38173 жыл бұрын
@@TheRevitKid so ominous!
@jmqrsq8 ай бұрын
@@TheRevitKid Do you have a link to this video you said to Tune in for? I have looked through all of your videos and I cannot find anything. =)