I am enthusiastic about Speckle and the possibility of using my model data in PowerBI.
In the meantime, I have been able to integrate both the extension and the viewer into PowerBI. I can also load models.
The Psets (e.g. Pset_WallCommon) can also be integrated without any problems. Accordingly, I can generate specific queries at property level.
My problem is that I do not get any quantities displayed. I have already tried it with different models from different systems in versions IFC2x3 and IFC4. The values are displayed in well-known viewers such as Solibri, BIMVision and BIMCollab.
As already mentioned, the Psets and the values they contain are displayed. Unfortunately, the quantities and their values are not. The values are also not displayed in the speckle viewer (web). e.g. Qto_WallBaseQuantities can be seen in the viewer, but without values.
It’s really strange. I have checked all the models again. Even in the older web version (Stream), the BaseQuantities are not displayed. You can see in the picture that the set is expanded.
I have tested the extraction as described. I can extract everything except the geometric values “null” is displayed everywhere.
Does your IFC file have that property set? If yes, can you please share Speckle Model URL and the source IFC file so we can try to reproduce on our end.
It would be great if you could find out what the problem is. I work for the city of Zurich and we are looking for a suitable viewer for PowerBI. I am convinced that your solution would be the right one.
Attached are the two IFC files and two image sections (Qto) from Solibri:
Thanks for sharing the files. I can confirm some properties are missing when uploaded into Speckle and they are visible in other web based IFC viewers. So it’s something we need to improve.
In the meantime, you can use our Archicad connector to get your models from AC to Power BI.
Thank you very much for your support. I am pleased to see that it works in principle.
Unfortunately, as a city (owner), we are only served with IFC files for all projects. Unfortunately, we do not have access to the native data. It would be great if you could improve the IFC upload.
We are very impressed with your solution and would like to get in touch with you regarding a SAAS solution. If the upload via IFC files would work, that would be great.
PowerBI is an important part of our system landscape and we would very much like to equip various dashboards with your solution.
It would be great if you could keep me informed about the “quantities” from the IFC.
Would it be possible for me to have project 1 (including quantities) in my dashboard so that I can access it and run more tests in PowerBI in the meantime?
This would be great as I would like to show the functionality of Speckle to a larger group of interested parties in the near future.
Hello everyone, has the problem been solved?
I need to see PSets relating to quantities in a specific Pset, but as already highlighted on speckle these properties are not read.
Having to use the file in Power BI, I solved the problem by exporting an ITO from Solibri to Excel and connected the two queries (model and ITO) in Power BI.
Unfortunately I have no way of using Navis to connect directly and above all I don’t like the flow being able to do it directly by loading the ifc on speckle.
The ifc file is generated by Archicad in 2x3 format; I attach it.
I also attach the screenshot of the properties visible in solibri, and those “not” visible in speckle.
I think the problem is due to the units of measurement: the other properties (strings) work perfectly.
As I say, the IFC parser is being updated from the base IFCjs version. If you are able to share the file that isn’t processing, let me know.
While the ArchiCAD connector is entirely in the hands of Speckle developers and contributors, the IFC parser relies on external dependencies so we have less control and flexibility with regard to improvements and fixes.
! 
