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.
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/
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/
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/
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
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/
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/
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.
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/
I know nothing about Power BI, but this looks pretty cool!
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.
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
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/
Great video, inspired me! Which SketchUp license did you used for this?
Only SketchUp Pro is capable of loading extensions, which 3DBI for SketchUp is.
Sketchup lisansı aldığımız da 3dbi lisansı almış olmuyoruz o kısmı çözemedim baika bir yolu bar kı yani tek lisans ile çözemiyormuyuz?
Hello please I have the data set you used for this?
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/
How did the excel file is made... pls help us making that excel file
Thanks in advance
how do i Get this Rack Stand in SketchUP
This is actually pretty neat
Thank you Ahmad. Feel free to let us know if you have any questions.
Hi, I'm really interested but i dont find how to download add on in power bi thx
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/
@@informaxyz thank u so much!!!!
trying to have heat maps in that would be cool
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/
hey, do you still work on warehouse 3d visualizing?
This is what i want to learn
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/
@@informaxyz thanks. but, i am wondering that if we can contact for exchanging some information?
Very interesting, I'm intermediate in PBI, I will start to apply 3d visualising with PBI in mining and geology field
thanks a lot for the video
can i use another location id and it still works?
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/
Please give me the 3dbi download file
Bro how to link 3d model to data.
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/
i have tryed to make this but for some reason my model is working really slow
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
Price ?
How to add project winform?
That is awesome. May I have this 3D model and dataset for exercise this? sincerely
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/
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?
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/
How to sort order when export location. ex: A-3-12 to A-12-3
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/
3DBI free or paid ?
Wow, This is exactly what my manager is expecting me to do.
Olá, sou do Brasil, consigo criar um modelo personalizado para minha empresa?
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.
Kindly share the data..
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/
This is great~!
name aplikasi
That's amazing
Glad that you like it!
skusavvy has something similar
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.
Omg 😮
Shooow
The best
Thank you, Michel.
완전 충격받았습니다...
Toppppp