Displaying model in PowerBi
-
There are some 3D viewers for PowerBI like:
- Tracer: https://apps.provingground.io/tracer/
- EZPowerBI: https://ezpowerbi.wordpress.com/tag/ifc/
-
Other tools that allow the visualization of models in PowerBI are
Vcad https://www.bimservices.it/
KG-dev https://kg-dev.be/project/3dbi-for-revit/I have personaly tested Tracer from ProvingGrounds. It is a very good tool to visualize models and interactive as you are requesting.
-
Thanx for the tip @chris. I will also give it a look.
The price is a bit high thout (I think!). Do you use is so much in one or two projects (standard plan) during a month period?
Sorry, we drifted a bit from Solibri with this Topic
AllesWirdGut Architecture
www.awg.at -
3D Repo also started some developments by the beginning of this year.
https://3drepo.com/power-bi-custom-visual/
I like the workflow (they have a well-documented API that might nicely handle automated processes), but the viewer still lacks behind. -
Hi. An upcoming Solibri version makes this directly possible without exporting any data to outside files or databases, so if you are interesting in testing it out, join the testing group https://society.solibri.com/topic/1194/upcoming-solibri-version-testers-wanted
-
@lasse-lindqvist said in Displaying model in PowerBi:
An upcoming Solibri version makes this directly possible without exporting any data to outside files or databases
Makes what possible?
-
@jsn said in Displaying model in PowerBi:
@lasse-lindqvist said in Displaying model in PowerBi:
An upcoming Solibri version makes this directly possible without exporting any data to outside files or databases
Makes what possible?
It allows you to load a Solibri project file to PowerBI and visualize data such as classification results, ITO calculations and checking results.
The 3D data is available as well, but there also seems to be some PowerBI visualizer that work with IFC sources based on the links.Not sure how well they work in reality. -
@Jack-Allason @chris @Nuno @agroni @Alexander-Joslyn @JSN
Here is a simple example of saving a model to a new file format (.solibri) with the new Solibri version (currently in alpha) and visualizing the classifications of the model in PowerBI:
As @lasse-lindqvist mentioned it is also possible to access other data in the models.
-
@Lauri-Luoma
that looks very promising.
I assume that this .solibri database is readable in PowerBI and other queries could be generated.
Respectively, is the type of information in the .solibri file adaptable, meaning that we can decide what to export?AllesWirdGut Architecture
www.awg.at -
@Lauri-Luoma Great News! To have a Solibri 3D Viewer Visual directly in the PowerBI would be really great…
-
@agroni said in Displaying model in PowerBi:
I assume that this .solibri database is readable in PowerBI and other queries could be generated.
Respectively, is the type of information in the .solibri file adaptable, meaning that we can decide what to export?Will it blend, that is the question!
Would be indeed good to know if there are custom visuals involved - as I assume there will most likely be one for the mentioned 3D view - and can the data be accessed as tables e.g. to create relationships and use it with other visuals? Anyhow, good to see that progress is made in that direction as well!
-
@lauri-luoma this looks interesting. How do I open the info in PowerBi? Is it still having to be exported into an excel, or is it straight from a solibri file?
-
@jack-allason said in Displaying model in PowerBi:
@lauri-luoma this looks interesting. How do I open the info in PowerBi? Is it still having to be exported into an excel, or is it straight from a solibri file?
PowerBI can read the Solibri file directly, without any need to export to Excel or other formats. You will need to import the Solibri file as an SQLite 3 database file as an ODBC datasource. More instructions on that can be found for example in https://www.biinsight.com/visualise-sqlite-data-in-power-bi/ but we will also provide more detailed instructions on how to work with Solibri files later.
-
It would be nice to see an example for this connection.
I tried to follw the instructions in the site you refer. As path to the database I gave a solibri file. However I don’t get access to any table:
I wounder about what I have missed, or if it is just possible with the export with Solibri API, or if it is possible with files save in the current version, or in the coming version Solibri 10…
I’m looking forward to use this funcionality of Solibri.
Regards
Nuno
-
Hi. It is only available in the upcoming unreleased version that is currently only available for alpha testers. Sadly I don’t have instructions on setting up the connection, as it does require installing some things for PowerBI and is not available out-of-the-box, but I hope we can have those out in the near future.
-
@Lauri-Luoma Hi!
I find this functionality very usefull
Do you have a map with the relations between the tables or some tips about it that you can share?
Regards
Nuno
-
@Nuno said in Displaying model in PowerBi:
@Lauri-Luoma Hi!
I find this functionality very usefull
Do you have a map with the relations between the tables or some tips about it that you can share?
Regards
Nuno
Basic tables:
COMPONENT holds basic info about components
SLIDE, PRESENTATION, PRESENTATION_SLIDE about presentations and slides
VIEWPOINT, VISUALIZATION, SNAPSHOT the picture related stuff about slides.
COMPONENT_SOMESUBCLASS contains some subclass data about certain components. Connects to COMPONENT via ID field.
RELATIONS_XYZ contains the IFC-relations for components
STRING table contains deduplicated texts. Many tables reference this via the ROWID column. For example COMPONENT_SITE has NUMBER_STRINGS_ROWID column.
COMPONENT-COMPONENT_PROPERTYSET-PROPERTYSET-PROPERTYSET_PROPERTY-PROPERTY can be joined to find all properties from IFC propertysets.“DB Browser for SQLite” is useful GUI application for browsing what is in the file.
Copyright © 2025 Solibri Inc. | Powered by NodeBB