I used your method to export the Object ID as a CSV file. I added a few new columns and filled in the values. Then, I imported this CSV into Power BI and established a relationship between the two data sources using the Object ID as the common link.
The test result shows that if the data is not from Speckle ‘raw_data’, the information can’t be displayed in the table. For example, “data.name” won’t appear.
Interaction between the 3D model and data will only occur within the 3D model
and Speckle data.
Selecting data from the “Manually add value (CSV)” table will impact the model object and Speckle data. For example, I select “Survey 2-3 yrs ago” in the slicer, the corresponding object in the 3D model will be selected, and the data in the tables will also change.
However, clicking on the object in the 3D model won’t show any value from the CSV.
Maybe my model’s data are too complicated. Comparing with your data, yours look very clean.
Are there any way to improve my model data? Thanks again for your help.
I have uploaded 2 files to the google drive.
3D model test notes 18022025
3D model viewer 2.0.0 test 18022025
Could you please add the source SketchUp file to the same drive folder? I’d love to help out, but I’ll need access to that file to really understand what’s going on.
@judywu0102 I cannot assist you without the source SketchUp file. as I said in my earlier response. Please provide a minimal reproducible SketchUp file so I can help you resolve the issue you’re facing.
Thank you for sharing the file. I reviewed your model and added attributes to the containers. I loaded part of it into Power BI and experimented with coloring. It appears to work when I filter the elements, so I suggest checking for any errors in your loaded data.