Power BI EXPORT

CONTENT

What is Power BI?

Power BI Export tool and how does it work?

Visualize your data in 2D and 3D

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

• Settings:

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.

• Selection:

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.

[1] 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 

Example:

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.

Use Power BI Export for visualizing your Revit data

The interactive dashboard allows you to customize your data representation and emphasize what matters the most