Displaying model in PowerBi
-
@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.
-
@Nuno said in Displaying model in PowerBi:
Thanks Lasse!
Do you also know the sequence of tables for ITOs and Classifications?
Regards
Nuno
CLASSIFICATION
ITO
These contain XML in them.CLASSIFICATION_RESULT
This has a column pointing to INTEGERLIST table and the list of integerers is the ID-fields of the components in question.
ITO_RESULT-ITOROW-ITOCELL
ITOROW represents one row in the ITO results table and ITOCELL one cell (think of Excel cells). ITOCELL might reference other tables, such as MATERIAL table in case the cell represents a color/material. -
@lasse-lindqvist said in Displaying model in PowerBi:
as a column pointing to INTEGERLIST table and the list of integerers is the ID-fields of the components in questio
Hi Lasse,
Can you be more precise, please.
CLASSIFICATION_RESULT as a field COMPONENT_SET_SET_ID. Is this one that connects to INTEGERLIST (I supouse to LISTID field)? Then I would supouse the VALUE field from INTEGERLIST would connect to ID in COMPONENT table. Is this what you mean?
There is another table COMPONENT_SET. Is this needed?
I still don’t get the total components for each classification…
Regards
Nuno
-
@Nuno said in Displaying model in PowerBi:
@lasse-lindqvist said in Displaying model in PowerBi:
as a column pointing to INTEGERLIST table and the list of integerers is the ID-fields of the components in questio
Hi Lasse,
Can you be more precise, please.
CLASSIFICATION_RESULT as a field COMPONENT_SET_SET_ID. Is this one that connects to INTEGERLIST (I supouse to LISTID field)? Then I would supouse the VALUE field from INTEGERLIST would connect to ID in COMPONENT table. Is this what you mean?
There is another table COMPONENT_SET. Is this needed?
I still don’t get the total components for each classification…
Regards
Nuno
It uses INTEGERLIST table only. I hope we can get rid of the COMPONENT_SET table before the release. It is used in one place for grids/gridaxes.
-
@lasse-lindqvist hi!
Could you please explain how can I try this unreleased version?
I really need to try this connection with powerBI -
As a BIM and PowerBI nerd, I would say that the best way to integrate large Revit/IFC models into PowerBI is through VIM AEC, the company I work for. We are looking forward to Solibri making their data available to PowerBI so that we can showcase an integration and release templates for users.
Check us out here at vimaec.com
Copyright © 2025 Solibri Inc. | Powered by NodeBB