Dynamic Data *Images* with Revit and Power BI (Synoptic Panel)

Dynamic Data Images with Revit and Power BI (Synoptic Panel)

Рет қаралды 25,198

Күн бұрын

On this episode of BIM After Dark Live I will be showing you the process of connecting Power BI visual data to 3D model images created in Revit...
Essentially, this is the next best thing to actually having your models IN Power BI... We'll get to that next week... ;)
If you are wondering what this could look like, check out this link (app.powerbi.com/view?r=eyJrIj...) and click the images of the building on the top right... See how you can interact with the image and the data dynamically?! That is what I will show you in the episode...
Topics Covered:
- Exporting Images
- Making a "smart" layered SVG file (Adobe Illustrator)
- Using "Synoptic Panel" in Power BI
- Tying it all together...
Links Mentioned:
Get a BIMBOX Today (let them know I sent you) - bimbox.bimafterdark.com
BAD Live - Episode 18 (Power BI) - therevitkid.blogspot.com/2020/...
TimeStamps
0:00 - Intro
1:07 - BIM BOX
6:04 - Dashboards
11:31 - Creation process of 3D Model Images
15:51 - Exporting Images
16:22 - Exporting Revit Data for Power BI
20:29 - Making a smart layered SVG file in Adobe Illustrator
27:28 - Power BI basics
30:54 - Using Synoptic Panel in Power BI
33:53 - Adding Cost data in Power BI
35:18 - Exporting links in Power BI
36:30 - Recap
38:18 - Question/Answers
42:01 - Outro
Here are some links to all of the hardware and software I use:
My Main Revit Computer (BIMBOX) - bimbox.bimafterdark.com/
How I Record My Tutorials (Camtasia Studio) - techsmith.z6rjha.net/zVvgW
My Microphone (Blue Yeti USB) - amzn.to/3992DYy
My Studio Headphones (Sennheiser HD 600) - amzn.to/2PxTFwj
My Camera for Videos and Images (Canon EOS 80D) - amzn.to/32zbpg5
The Lens I use for these videos (50mm) - amzn.to/3cvIE8D
My Webcam for Webinars (Logitech C922X) - amzn.to/2wP3AHf
My Favorite Sketchbook (“Blank” by 30x40) - amzn.to/32yAffZ
My Favorite Sketching Pens (Sharpie “Fine”) - amzn.to/3c8r8qO
Greatest Sketching Marker of All Time (Sign Pen) - amzn.to/3ceAukN
** Some of the above links are affiliate links, meaning you don’t pay anything more but I may get a small commission for a sale… Cheers! **
Music: Sexy from Bensound.com
Music: Badass from Bensound.com
Music: Happy Rock from Bensound.com

Пікірлер: 46

@leben1841 3 жыл бұрын

Thank you very much for this introduction to PowerBI. I did not know this tool at all and I find it very interesting. Thank you again for your excellent work.

@rafaellucki2709 2 жыл бұрын

these powerbi combination with revit has a lot of potential for me! thanks for these videos and i wish for more material about these!

@TheRevitKid 2 жыл бұрын

Cheers! So glad you've enjoyed! I will definitely talk about it again!

@yousrakadcha7949 3 жыл бұрын

So interesting, thanks for sharing!

@johng5295 2 жыл бұрын

Thanks in a million. Great content. Awesome. Very well explained. I couldn't find this explanation--simply put anywhere else. Great teachers are hard to find. Grade: A++💥

@TheRevitKid 2 жыл бұрын

Cheers John!!

@Reza15831 Жыл бұрын

Great video! Happy I to find this

@TheRevitKid Жыл бұрын

Cheers! I am glad you found it as well! :)

@lispavr963 3 жыл бұрын

Thanks so much

@guhsk81 3 жыл бұрын

very gooood!!

@anabelengutierrez8310 3 жыл бұрын

Thanks you for sharing¡ Is more interesting, and you have given me a great idea¡¡¡

@TheRevitKid 3 жыл бұрын

Thank you! Cheers!

@gregmcbride3772 3 жыл бұрын

wow, thats amazing, Im a lighting engineer and work with cad and dialux all the time, these models, and the way the information is presented is mind blowing. wanna know more!!!!

@danielkrajnik3817 3 жыл бұрын

I wish there was a way to read rvt files without having to open revit. are there no CLI tools? something in their SDK?

@reedweinstock1514 2 жыл бұрын

#TheRevitKid Would love learn more about strategies for deploying Power BI to projects, how to streamline setup, and how to automate push data of revit to a database without user input

@gatiendeniaud9089 Жыл бұрын

Hi, I need help with a synoptic panel. I would like to change individual maps via a slicer. Ie. I have a list of 20 buildings, each building has several floors and I want my map to change as I choose buildings in the slicer. Thank you for your help

@brundog9 2 жыл бұрын

I apologize in advance if this is a dumb question, but if you publish the dashboard would the end user be able to zoom and rotate the 3D image of the house? Say for example if they selected glass and needed to rotate the house to see the windows in the front that were highlighted by the material selection.

@brundog9 2 жыл бұрын

Disregard. After re-watching, I see the house is an image saved and not the actual 3D model itself. So I am guessing you would need multiple images of the house if you wanted to encompass all sides of it?

@TheRevitKid 2 жыл бұрын

@@brundog9 check out my episode with Nathan Miller talking about Tracer >> therevitkid.blogspot.com/2021/03/interactive-3d-revit-models-in-power-bi.html?m=1

@charlesball9522 2 жыл бұрын

Are you using displace elements is Revit to create the exploded axonometric views?

@TheRevitKid 2 жыл бұрын

A couple of different methods... See here >> kzfaq.info/get/bejne/aa6BgK6asZetmWQ.html

@user-zs1bk9su5l 3 жыл бұрын

Hi, i am just wondering how to show the data in panel at 07.41, i am using panel in power bi and i can connect between any table in power bi and layer in panel. But i cannot show the data next the panel image like percentage. Could you please advice for me little bit?

@TheRevitKid 3 жыл бұрын

As long as you're pulling from the same grid data and the layers in the panel are named exactly like the data it should work. Most likely, you are not pulling from the same grid or the panel layer names don't match up.

@kristofferdahlquist4930 Жыл бұрын

Awesome! How do you conditionally format the colors on selected/non selected floors in Power BI?

@TheRevitKid Жыл бұрын

It's all built into the Synaptic Panel tool... You can built rules, conditions, etc... as long as you setup that SVG correctly to start.

@kristofferdahlquist4930 Жыл бұрын

@@TheRevitKid Would love if you made an episode showing how you went from adding the layer areas in Illustrator to creating and formatting the image in Power BI to create the dashboard in the 6 minute mark in your video!

@TheRevitKid Жыл бұрын

@@kristofferdahlquist4930 I literally show you that in this video lol… Around the 31 minute mark I show you how to bring in the SVG and link it to your data.

@kristofferdahlquist4930 Жыл бұрын

@@TheRevitKid I meant the part where you actually use and format the SVG image inside PBI to create the complete visual. For instance when you click on a floor level the level gets highlighted, but I can't seem to replicate the behaviour when I use the visual. If I click on a part of an image the entire image is greyed. :)

@TheRevitKid Жыл бұрын

@@kristofferdahlquist4930 I also talk about that around the 20 minute mark - 20:29 - Making a smart layered SVG file in Adobe Illustrator

@gauravtiwari6392 2 жыл бұрын

Hello there, nice video. I am doing the exact process you've described in this video. However the svg doesn't load in the imported OKViz visual, designed used Adobe Illustrator. Can you help please? P.S: I am doing this in 9.8.2021

@TheRevitKid 2 жыл бұрын

The image will not show until you put data to it (add a field from your BI grid to the visual)

@gauravtiwari6392 2 жыл бұрын

@@TheRevitKid Thank you for putting you time to this comment of mine. Actually, the issue wasn’t about addressing the categorical and quantitative measures within the slots. It was more about svg being blurred if I use Adobe. If I use any other tool like Inkscape, this gives black patches to the sections which were highlighted using this tool. This is bit difficult to explain as you can’t put images as comment to describe these design issues. However this was my small attempt in getting this across you as these issues are faced by many. Thank you for your time 🙏🏻

@gauravtiwari6392 2 жыл бұрын

@@TheRevitKid By the way, I’ve watched your video 5 times. ☺️😍 The dashboards are really mind blowing. 👍🏻

@TheRevitKid 2 жыл бұрын

@@gauravtiwari6392 cheers! So glad you enjoy them! I am not sure about the blurred SVG. As you can see from my examples we don’t have that issue (and we use illustrator).

@user-zs1bk9su5l 3 жыл бұрын

Hi, i am really interested in this, if you don't mind and have a time, could you please explain specifically how to make that dashboard at 07:21

@TheRevitKid 3 жыл бұрын

That would require an entire episode! The dashboard itself is in Power BI and uses synoptic panel over the image on the right. All of the rest of it is data being pulled from various models. We use assemble systems to host our models and have our field staff input data... then pull that data from the Assemble systems server.

@user-zs1bk9su5l 3 жыл бұрын

@@TheRevitKid thank you for responding, could you plz let me know how to connect between powerbi and image? 1. i made to distinguish by using layer in adobe photoshop. 2.i have tried to use that image as svc in power bi with my data. but it doesn't work between power bi graph and that image.

@TheRevitKid 3 жыл бұрын

@@user-zs1bk9su5l - I show exactly how I do it in the livestream above... Follow the process and you should be good!

@user-zs1bk9su5l 3 жыл бұрын

@@TheRevitKid okay. i got it. However, if i use just image( not from revit), is it possible to use that image in powerbi? i mean after using that image by using in photoshop, i want to combine edited image and my data in powerbi. these are not any connection between edited image and my data. For example, a Structural Drawing(image file) is not from revit. then after making layer setting in photoshop (changing svg file), then can i combine my data and and that image? what is the connection ? cuz i have been trying....but it doesn't work actually.... plz let me know. Thanks. Kind regards.

@TheRevitKid 3 жыл бұрын

@@user-zs1bk9su5l Yes, the image can be from anywhere... As long as it has layers who's names align with at least one column of data ... The images and data don't even have to be from Revit, they could be a photo of a building and an Excel sheet, as long as you have layers with names that align with the data.

@user-ce6rg2gt9g Жыл бұрын

I need the ability to be changed based on filter loaded images in Synoptic Panel visual.

@TheRevitKid Жыл бұрын

Can you be more detailed in your explanation …? That is exactly what I am showing, no?

@user-ce6rg2gt9g Жыл бұрын

@@TheRevitKid I need the ability to be changed based on filter loaded images in Synoptic Panel visual I have loaded multiple svg images in one Synoptic Panel visual but how to swith them by filtering?