@JLAR
The best would be to keep your location labelling structure in mind when setting up the 3D model’s hierarchy.
Imagine you have labels like: R01-001-003 where R01 is the row, 001 is position and 003 is the level.
When creating a 3D model it is best to start creating the components that represents the last item in your labelling structure, thus, the individual pallets for each level. If your warehouse has 5 pallets on top of each other, you start with these 5 and name them 001, 002, 003, 004 and 005.
Then: group these 5 pallets in a new component, and duplicate that component for each position in the row. For example, you might have the following positions in a row: 001, 003, 005 and 007. You thus have to duplicate the component that contains 5 pallets 4 times, and name them 001, 003, 005 and 007.
You now group again these 4 components in a new component, effectively creating a component that represents an entire row. Image you have rows R01, R02 and R03, you now duplicate this component another 2 times, so you end up with 3 components representing a row.
If you now finally name these instances R01, R02 and R03 and provide during the export settings that you want to use the instance name as id provider, as well as concatenate them, 3DBI will use the different names found in the 3D model hierarchy to generate unique identifiers for each pallet.
Another thing to consider, please make your geometry as abstract as possible.
Power BI visuals have limited access to device resources. The amount of memory consumed is based on the number of unique so-called vertices in your 3D model. Complex shapes have more vertices than abstract ones. For example, 1 cube has 8 vertices. A cylinder on the other hand could be made of 100’s of vertices. If your model contains lots of complex (or rounded) geometry, you will at some point hit a RAM memory limit.
There are a few solutions:
- Limit the number of elements. For example, only export the elements that are needed for your dashboard. In SketchUp you could hide all elements and then check the option to only export visible elements.
- Limit their complexity. In SketchUp, 3D models downloaded from 3D warehouse can be bloated with geometry. It is worth cleaning up that geometry by making less complex and abstracted models prior to exporting.
For example, the following report contains a model with around 30k individual locations. By keeping geometry as abstract (though recognizable) as possible, performance is drastically improved: Microsoft Power BI
