Power BI EXPORT
What is Power BI?
Power BI is a data visualization platform developed by Microsoft. It allows you to unify data from many sources to create interactive, immersive dashboards and reports that help you gain deeper data insight into your project.
With the Power BI Export tool, which is part of the Kobi toolkit 2022 release, you can now use Revit data for creating tables, graphs and visual representations of a BIM model. Once exported, it allows you to efficiently review and manipulate the data without needing to open the Revit file. Perfect for meetings, creating reports or quick reviews.
Power BI Export and how does it work?
Click on the Kobi Toolkit tab Go to Analysis Panel Select Power BI Export tool
You can use Power BI Export in any view. Choose where you want to select data from (Selection, Active View, Model).
- Check boxes:
> Strip units – Exports dimensions without units (recommended for working with Power BI).
> Export 3D Mesh – Exports 3D mesh geometry (if the geometry is too complex, it will export bounding box)
- LOD (Level of Detail) – Select level of detail in values from 100 to 500.
Select families and elements you want to export by checking boxes in front of the elements use toolbar to:
> Select all nodes
> Deselect all nodes
> Invert checked nodes
> Collapse all nodes
> Expand all nodes
Website – opens KobiLabs website with additional information about the tool.
Select Export and save it as Excel (recommended) or CSV file.
Open Power BI Desktop and select Get data.
Depending on the exported data type from Revit, select Excel or Text/CSV format and select Connect.
When the Navigator dialog window opens, select Kobi Toolkit for Power BI and click Load.
 Revit: Kobi Toolkit tab Go Analysis Panel Select Power BI Export tool Visual (copy the path of the folder that opens up)
Go to Visualizations Click on … Import a visual from a file Find Kobi KobiLabs Power BI Visuals Open
By opening the files (kobi_toolkit_for_powerbi_2d.1.0.21 and kobi_toolkit_for_powerbi_3d.1.0.9) you can now create custom visualizations of Revit data in 2D and 3D.
Visualize your data in 2D and 3D
1.)Select 3D visualization (kobi_toolkit_for_powerbi_3d).
2.)In Fields select the data you want to use, for instance: ID, Name, Area, First Pbi3DGeometry (note: if you are doing a 2D visualization, select First Pbi2DGeometry).
3.)Insert the data by dragging and dropping in selected rows (ID, Caption, Values, Geometry) – Pbi2DGeometry contains geometry for 2D visual and Pbi3DGeometry for 3D visual.
You can change colour combinations under the View tab.
3426 NW 14th Ave
Camas, WA 98607
Podutiška cesta 92
1000 Ljubljana, Slovenia
To apply for a job with KobiLabs, please send a cover letter together with your C.V. to: email@example.com