3D warehouse in Power BI - using 3DBI

Video demonstrating the workflow needed to get a Trimble® SketchUp® model of a warehouse into Microsoft® Power BI® to be able to dynamically filter and colorize pallet locations based on various data fields. Read more about it here: kg-dev.be/2021...

[@jiminybb]

I know nothing about Power BI, but this looks pretty cool!

[@informaxyz]

Power BI is a tool by Microsoft that let's you connect to various data sources (Excel files, xml/json, databases, webservices,...) and use that data to create interactive dashboards in just a few clicks. It cannot, out of the box, visualize 3D models. That is the part we added, with 3DBI you are able to bring in any SketchUp model (or Revit) into Power BI and use the data that is there to colorize and filter objects in that 3D model. In this video it is a warehouse, but it could also have been a collection of rooms in a building where you use IoT sensor data to colorize and filter rooms, or parts of a machine that are highlighted based on when they require maintenance, ... The goal is to add spatial insight to data, so you can see what is where.

[@anozanb]

Very interesting, I'm intermediate in PBI, I will start to apply 3d visualising with PBI in mining and geology field

[@SamirHiddani-bd7rn]

trying to have heat maps in that would be cool

[@informaxyz]

You could use conditional formatting to achieve that. More information can be obtained here: kg-dev.be/2022/11/17/new-feature-conditional-formatting-in-3dbi/

[@anozanb]

I have idea to import 3D solids from mining planning software and import them in Power Bi with production data, but I don't know how to do this

[@informaxyz]

Hi, if you can bring your 3D model into SketchUp, you could then use our custom 3DBI for SketchUp extension to bring it from there into Power BI: kg-dev.be/project/3dbi-for-sketchup/

[@ahmadh.7016]

This is actually pretty neat

[@informaxyz]

Thank you Ahmad. Feel free to let us know if you have any questions.

[@FinalFlashRony]

How did the excel file is made... pls help us making that excel file Thanks in advance

[@bismarckafuzie2021]

Hello please I have the data set you used for this?

[@informaxyz]

Hi, you can download the complete .pbix on the following page: kg-dev.be/2021/08/16/how-to-custom-3d-power-bi-visual-of-a-warehouse/

[@kaledbelabed9241]

thanks a lot for the video can i use another location id and it still works?

[@informaxyz]

Yes, you can add any ID to each element. You can learn here how to do that: kg-dev.be/2021/08/16/how-to-custom-3d-power-bi-visual-of-a-warehouse/

[@mortezaabootaleby3724]

That is awesome. May I have this 3D model and dataset for exercise this? sincerely

[@informaxyz]

Yes, it can be downloaded directly from the tutorial page: kg-dev.be/2021/08/16/how-to-custom-3d-power-bi-visual-of-a-warehouse/

[@isabelacristina9307]

Great video, inspired me! Which SketchUp license did you used for this?

[@informaxyz]

Only SketchUp Pro is capable of loading extensions, which 3DBI for SketchUp is.

[@RAJ-sk4fp]

how do i Get this Rack Stand in SketchUP

[@acrostoa]

Great video. How do I name each pallet position so it links with my data? Do I select the pallet, enter the location into the Definition field?

[@informaxyz]

Hi, thank you for your message. The following tutorial handles in depth about this type of workflow: kg-dev.be/2021/08/16/how-to-custom-3d-power-bi-visual-of-a-warehouse/

[@Marco-ss5jp]

That's amazing

[@informaxyz]

Glad that you like it!

[@gunag4811]

Bro how to link 3d model to data.

[@informaxyz]

We have quite some tutorials available on our website that cover various topics: kg-dev.be/2022/11/07/how-to-3d-real-estate-dashboard-in-power-bi/

[@Luaresify]

Hi, I'm really interested but i dont find how to download add on in power bi thx

[@informaxyz]

Hi, thank you for your message. The steps needed to get this visual in Power BI are described in the following tutorial: kg-dev.be/2021/08/16/how-to-custom-3d-power-bi-visual-of-a-warehouse/

[@demetriomenezes6060]

@@informaxyz thank u so much!!!!

[@1KEVINFLYNN]

This is great~!

[@RAJ-sk4fp]

i have tryed to make this but for some reason my model is working really slow

[@informaxyz]

You get the best performance when you keep geometry as abstract as possible. For example, the following report contains roughly 30.000 objects while still performing well: app.powerbi.com/view?r=eyJrIjoiZDcwZjg0NmUtY2EyMS00OGQ3LWJjYjAtYWQ3ZTY2YWM5YmUzIiwidCI6ImFlYzBjYTkzLTc5MGEtNDU0MC05NjY3LWI2ODdmNjViNGNkZCIsImMiOjl9

[@michelpioker8596]

The best

[@informaxyz]

Thank you, Michel.

[@singhi89]

hey, do you still work on warehouse 3d visualizing?

[@ANTHONYROBLES88]

This is what i want to learn

[@informaxyz]

Yes, you can learn how to create these yourself over here: kg-dev.be/2021/08/16/how-to-custom-3d-power-bi-visual-of-a-warehouse/

[@bsmsofware7993]

How to add project winform?

[@sugaming8233]

Please give me the 3dbi download file

[@minhsangoan8325]

How to sort order when export location. ex: A-3-12 to A-12-3

[@informaxyz]

Hi, Always start right to left. If the last character of your location is 1, 2, 3 then first make 3 pallets (or other objects) and assign a 1, 2 and 3 as their ID. Then group them en duplicate them as per the second set of characters (1...12 for example) and assign those IDs to each group of pallets. You can learn more about it here: kg-dev.be/2021/08/16/how-to-custom-3d-power-bi-visual-of-a-warehouse/

[@gaabrielcouto]

Shooow

[@user-ns9nf2rd8q]

Olá, sou do Brasil, consigo criar um modelo personalizado para minha empresa?

[@informaxyz]

Hi, yes, you can follow the steps from the following tutorial to create a custom model suitable for your needs; kg-dev.be/2021/08/16/how-to-custom-3d-power-bi-visual-of-a-warehouse/ Or, we can also create the model for you and help you getting started with Power BI. Please feel free to reach out if you want us to create the model and dashboard for you.

[@user-ur5fk4im9u]

Price ?

[@kutubuku1209]

name aplikasi

[@gunag4811]

Kindly share the data..

[@informaxyz]

Please find a step-by-step tutorial as well as related data on the following page: kg-dev.be/2021/08/16/how-to-custom-3d-power-bi-visual-of-a-warehouse/

[@user-qk2nl8lf9y]

skusavvy has something similar

[@informaxyz]

That might be possible. The benefit of 3DBI is that it runs in Power BI, which gives you the possibility to load and display any data you have.

[@onecrore2210]

3DBI free or paid ?

[@leewon0115]

완전 충격받았습니다...