Generate interactive dashboards and reports from SketchUp models in Microsoft Power BI

Thank you, I appreciate your feedback :slight_smile:

Something else that might be interesting about 3DBI: although originally indented to bring data and 3D to Power BI it seems that Excel can also connect just fine to the data we export from SketchUp.

With 3DBI you have the option to also export data together with the .3dbi model. We do store that data in a .json file, which is somewhat a standard data exchange format nowadays. Now, Excel can import (or better, connect to) json files just as easy as Power BI can. Here is a short movie to illustrate that:

And, the reason I say “connect” instead of “import” is because whenever that .json file changes, Excel can sync with it instead of having to import it over and over again. So it is just a matter of doing an export in SketchUp again and then sync your data with Excel. (The same goes up for Power BI of course)

What data is included?
we export data regarding all component instances and groups and we export the following columns:

  • Id (which is the persistent id)
  • ParentId (which is the persistent id of the container element)
  • Name
  • Definition
  • Type ( Group or ComponentInstance)
  • IsVisible
  • Material
  • Volume (in square inch, SketchUp’s internal unit)
  • Volume.ModelUnits (thus the volume in the unit the model is setup)
  • all attributes in the entity info dialog, such as Price, Size, Url, …
  • all dynamic component attributes, so any attribute you have assigned to objects using Dynamic Components
  • all classifications and classification values, such as IFC
2 Likes