No video

Connecting Revit to Power BI : An Introduction to Visualizing Model Data

  Рет қаралды 54,987

TheRevitKid

TheRevitKid

Күн бұрын

Пікірлер: 74
@M0JHN
@M0JHN 3 жыл бұрын
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.
@agradoville
@agradoville 4 жыл бұрын
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
@kaisimon9894
@kaisimon9894 3 жыл бұрын
instablaster.
@cansuyeni
@cansuyeni 3 жыл бұрын
It is such a helpful tutorial. It is perfectly clear and understandable. Thank you for this great job!
@BillDebevc
@BillDebevc 4 жыл бұрын
Thank you for this great tutorial. It got me thinking of how to use Power BI
@TheRevitKid
@TheRevitKid 4 жыл бұрын
Bill Debevc - cheers bill! I hope all is well man!
@alexreeves4009
@alexreeves4009 2 жыл бұрын
Great video! Would love to see a deep dive on power BI dashboards for construction estimating and VDC practices!
@TheRevitKid
@TheRevitKid 2 жыл бұрын
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
@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
@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
@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
@TheRevitKid Жыл бұрын
@@RSBKCLIPS Very cool! Good luck man!
@MiralMahran
@MiralMahran Жыл бұрын
Thank you for sharing your thoughts. Loved this Tutorial 👏
@TheRevitKid
@TheRevitKid Жыл бұрын
Cheers! Glad you enjoyed. Thanks for tuning in
@fukuda6025
@fukuda6025 3 жыл бұрын
That's amazing.. still learning dynamo to understand fully that code, but definitely showed us a way to approach 5D BIM
@TheRevitKid
@TheRevitKid 3 жыл бұрын
Glad it was helpful!
@alenjertec6851
@alenjertec6851 2 жыл бұрын
This is awsome video. Thanks TheRevitKid! Really appreciate it. :D
@TheRevitKid
@TheRevitKid 2 жыл бұрын
Cheers! Glad you enjoyed !
@macoveialex6823
@macoveialex6823 3 жыл бұрын
Min 50:00 is what I was looking for.
@thiagonieves4357
@thiagonieves4357 4 жыл бұрын
You´re the man! Great job! I´m very eager to try that Revit Power BI integration.
@agradoville
@agradoville 4 жыл бұрын
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.
@TheRevitKid
@TheRevitKid 4 жыл бұрын
I'll add it to the list of topics. ;)
@48VAC
@48VAC 4 жыл бұрын
Great video. I don't get a chance to watch live.
@marv.innovations802
@marv.innovations802 Жыл бұрын
I love it, Kudos to you and thanks a million.
@TheRevitKid
@TheRevitKid Жыл бұрын
Cheers!!! Thanks for tuning in
@kittyblossom7342
@kittyblossom7342 3 ай бұрын
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.
@ryanrazer1
@ryanrazer1 2 жыл бұрын
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! :)
@TheRevitKid
@TheRevitKid 2 жыл бұрын
Ryan, thanks for the advise! I hope it helps some!
@zebastianberglundolsson5723
@zebastianberglundolsson5723 3 жыл бұрын
I would love to see a video about Assemble!
@TheRevitKid
@TheRevitKid 3 жыл бұрын
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
@zebastianberglundolsson5723
@zebastianberglundolsson5723 3 жыл бұрын
@@TheRevitKid Awesome! Really appreciate the content you are creating! :)
@maxipaxi6338
@maxipaxi6338 Жыл бұрын
This nice!! More information about this theme on the site?
@sai742
@sai742 2 жыл бұрын
46:00 i think revit 2022 can create a multi category schedule
@memyadventures2730
@memyadventures2730 3 жыл бұрын
You are an amazing person 👏🏻❤️
@maroofjamal575
@maroofjamal575 2 ай бұрын
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.
@TheRevitKid
@TheRevitKid 2 ай бұрын
Um... that is exactly what this video is.....?
@tatianabedregalflores4590
@tatianabedregalflores4590 4 жыл бұрын
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
@TheRevitKid 4 жыл бұрын
Tatiana Bedregal Flores - you didn’t steal anything!! I share it so you do exactly that !!! So awesome !!!
@anaele1976
@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
@RSBKCLIPS Жыл бұрын
Damn, I don't know what I'm doing wrong but my dynamo won't run properly...
@johngray2459
@johngray2459 4 жыл бұрын
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.
@TheRevitKid
@TheRevitKid 4 жыл бұрын
I could be wrong... but, this requires connection with Forge, no?
@M0JHN
@M0JHN 3 жыл бұрын
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.
@fam8026
@fam8026 3 жыл бұрын
Access is the solution
@bimobject_ben5718
@bimobject_ben5718 3 жыл бұрын
Thanks for sharing! Really nice run-through. I love that T you have on in the video, where can I get one?
@TheRevitKid
@TheRevitKid 3 жыл бұрын
Thanks man! What do you mean by “T”?
@bimobject_ben5718
@bimobject_ben5718 3 жыл бұрын
@@TheRevitKid sorry your t shirt.
@TheRevitKid
@TheRevitKid 3 жыл бұрын
@@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
@devadarshanbhadra Жыл бұрын
please upload the scheduled dataset so that can be practiced in powe-bi
@user-ef5tl8bh8b
@user-ef5tl8bh8b 9 ай бұрын
I click randomly of these 4 to enter schedule properties! Never click right lol.
@TheRevitKid
@TheRevitKid 9 ай бұрын
😂
@user-kv1fy3vp7x
@user-kv1fy3vp7x 3 жыл бұрын
Hi, great video! Thx Is it any colored filter for all color dim ant text ?
@TheRevitKid
@TheRevitKid 3 жыл бұрын
It's part of my template...
@DesignsbyCADPRO
@DesignsbyCADPRO 4 жыл бұрын
interesting way to use Revit... :)
@pavillon9365
@pavillon9365 3 жыл бұрын
Hi, That is incredibly interesting. Do you have a video that show us how to actually build that script? i am not Dynamo expert.
@pavillon9365
@pavillon9365 2 жыл бұрын
EDIT: In Revit 2021 System Families are included in MultiCategoty Schedule
@kfl3700
@kfl3700 3 жыл бұрын
I learned alot from your video. In Dynamo, is there a way to extract Type parameters rather than Instance parameters?
@TheRevitKid
@TheRevitKid 3 жыл бұрын
Yes, same process!
@ashokshrestha2119
@ashokshrestha2119 10 ай бұрын
Will there be more updates video related to power bi and Revit Link up
@TheRevitKid
@TheRevitKid 10 ай бұрын
The process from Revit to BI hasn’t changed much … other than the introduction of Tracer from proving grounds …
@netblingers6306
@netblingers6306 8 ай бұрын
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
@TheRevitKid
@TheRevitKid 8 ай бұрын
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
@thomasroyle3196
@thomasroyle3196 3 жыл бұрын
In Power BI how have you got the Count of family Type Column?
@TheRevitKid
@TheRevitKid 3 жыл бұрын
It comes from the data .... Pretty simple to get counts in Power BI
@muneebafzal185
@muneebafzal185 2 жыл бұрын
Based!
@vemareddydareddy7278
@vemareddydareddy7278 2 жыл бұрын
Please do the videos short length
@TheRevitKid
@TheRevitKid 2 жыл бұрын
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!?
@vemareddydareddy7278
@vemareddydareddy7278 2 жыл бұрын
@@TheRevitKid , Thanks for the response, You would have to include video for 3D images loading into Powerbi.
@leandroreati642
@leandroreati642 2 жыл бұрын
Nice shirt :)
@danielkrajnik3817
@danielkrajnik3817 3 жыл бұрын
*revit to txt to power BI. A bit disappointed. Dunno why expected power bi to speak directly to revit. back to python it is
@TheRevitKid
@TheRevitKid 3 жыл бұрын
Tune into the channel tomorrow at 1230 EST ... ;)
@danielkrajnik3817
@danielkrajnik3817 3 жыл бұрын
@@TheRevitKid so ominous!
@jmqrsq
@jmqrsq 8 ай бұрын
@@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. =)
Dynamic Data *Images* with Revit and Power BI (Synoptic Panel)
42:39
Power BI in Project Control for Planning Engineers
12:03
Osama Saad
Рет қаралды 57 М.
Matching Picture Challenge with Alfredo Larin's family! 👍
00:37
BigSchool
Рет қаралды 47 МЛН
拉了好大一坨#斗罗大陆#唐三小舞#小丑
00:11
超凡蜘蛛
Рет қаралды 14 МЛН
Пройди игру и получи 5 чупа-чупсов (2024)
00:49
Екатерина Ковалева
Рет қаралды 4,2 МЛН
Bony Just Wants To Take A Shower #animation
00:10
GREEN MAX
Рет қаралды 7 МЛН
Revit quantity takeoff report using Dynamo and Power BI!
26:30
Aussie BIM Guru
Рет қаралды 11 М.
Microsoft Fabric for Power BI developers - 3.5 HOUR FREE COURSE
3:29:41
Learn Microsoft Fabric with Will
Рет қаралды 30 М.
Introduction to OpenBIM, Native IFC, and Open Source AEC
50:46
Dion Moult
Рет қаралды 16 М.
Visualizing Revit Rooms in Power BI
23:48
Speckle
Рет қаралды 9 М.
ULTIMATE Power BI Tutorial 📊 Beginner to Pro Course (2024)
3:40:48
Pragmatic Works
Рет қаралды 40 М.
Automatic Construction Documents in Revit (w/ Miguel of EvolveLab)
1:00:25
Multi-Family / Mixed Use Revit Documentation Tips (w/Aaron Maller)
1:35:15
Viewing Revit Models in Power BI
11:57
Speckle
Рет қаралды 6 М.
Matching Picture Challenge with Alfredo Larin's family! 👍
00:37
BigSchool
Рет қаралды 47 МЛН