& Construction
Integrated BIM tools, including Revit, AutoCAD, and Civil 3D
& Manufacturing
Professional CAD/CAM tools built on Inventor and AutoCAD
Integrated BIM tools, including Revit, AutoCAD, and Civil 3D
Professional CAD/CAM tools built on Inventor and AutoCAD
Visualize data from a data exchange using the Power BI Connector and the visuals included in Power BI.
Type:
Tutorial
Length:
4 min.
Transcript
00:03
Using the Power BI Connector to load an Autodesk Data Exchange into Power BI
00:08
enables you to create customized reports and dashboards to assist with data analysis.
00:14
Once you import the Data Exchange and load the viewer visual,
00:17
you can display and analyze your data and models using any of the visuals included in Power BI.
00:23
First, you need to load the Power BI Connector visual, if you have not done so already.
00:29
In Power BI, from the Visualizations pane, click the More (…) menu and select Import a visual from a file.
00:37
In the Documents\Power BI Desktop\Custom Visuals folder, select Autodesk Data Connector for Power BI, and then click Open.
00:47
In the success message, click OK.
00:50
Back in the Visualizations pane, click the Autodesk Data Connector icon to add this visual to the Power BI report view.
00:58
This visual requires specific data fields, which you can add in the Visualizations group.
01:04
For the Model File field, you must provide a .viewer property from the list of Data Exchange properties.
01:11
You also need the Model ID, ID, and Value.
01:16
If you would like to add colors to any of the visualized elements, you can also add properties to the Color field, but leave this empty for now.
01:25
To add the .viewer property, in the Data pane, search for ".viewer," then drag it into the Model File field.
01:33
Elements included in the Data Exchange begin to display in the viewer.
01:38
Next, add the ExternalElementID to the model ID, ID, and value fields.
01:45
This will allow you to cross-reference the model elements with other data visuals you plan to include in your Power BI dashboard.
01:53
Search for "ExternalElementId," then drag it into the Model ID field, ID Field, and Value field.
02:01
Now, the visual populates with all the model elements included in the Data Exchange.
02:07
The viewer tools are like those found in the Autodesk Viewer in ACC.
02:11
You can access the Model Browser to review information about the model structure, view Properties of selected elements,
02:17
adjust the viewer Settings, Explode Model, Measure selected elements, or change the view to First Person.
02:25
You can use any of the available visuals included in Power BI to add a data visual to your report.
02:31
First, in the Visualizations pane, ensure that no other visuals are selected, as selecting a new visual will replace the existing one.
02:39
Then, select a visual, such as the Stacked Column Chart.
02:45
Once selected, the visual displays on the report and can be repositioned by dragging and dropping
02:51
or resized using the control grips.
02:54
The Data Exchange used here includes a specific number of curtain wall doors,
02:59
and you want this visual to display the different types of doors and their areas.
03:03
In the Visualizations pane, add specific properties to the relevant fields to display the desired data in the visual.
03:11
In this case, search for and add Type_name to the X-axis field
03:17
and add Area to the Y-axis field.
03:21
In the graph visual, you now see elements with a type name that is blank or undefined, as well as defined element types.
03:30
To refine this view, add Category as a data filter.
03:34
In the Data pane, select Category and drag it into the Filters on this visual group.
03:40
Then, choose the Doors category.
03:44
Now, in the visual, only door types display.
03:48
Click any bar in the chart to highlight elements in the viewer with the same type.
03:53
Click the bar again to remove the highlight.
03:57
Now you can visualize data from a Data Exchange using the Power BI Connector and the visuals included in Power BI.
Video transcript
00:03
Using the Power BI Connector to load an Autodesk Data Exchange into Power BI
00:08
enables you to create customized reports and dashboards to assist with data analysis.
00:14
Once you import the Data Exchange and load the viewer visual,
00:17
you can display and analyze your data and models using any of the visuals included in Power BI.
00:23
First, you need to load the Power BI Connector visual, if you have not done so already.
00:29
In Power BI, from the Visualizations pane, click the More (…) menu and select Import a visual from a file.
00:37
In the Documents\Power BI Desktop\Custom Visuals folder, select Autodesk Data Connector for Power BI, and then click Open.
00:47
In the success message, click OK.
00:50
Back in the Visualizations pane, click the Autodesk Data Connector icon to add this visual to the Power BI report view.
00:58
This visual requires specific data fields, which you can add in the Visualizations group.
01:04
For the Model File field, you must provide a .viewer property from the list of Data Exchange properties.
01:11
You also need the Model ID, ID, and Value.
01:16
If you would like to add colors to any of the visualized elements, you can also add properties to the Color field, but leave this empty for now.
01:25
To add the .viewer property, in the Data pane, search for ".viewer," then drag it into the Model File field.
01:33
Elements included in the Data Exchange begin to display in the viewer.
01:38
Next, add the ExternalElementID to the model ID, ID, and value fields.
01:45
This will allow you to cross-reference the model elements with other data visuals you plan to include in your Power BI dashboard.
01:53
Search for "ExternalElementId," then drag it into the Model ID field, ID Field, and Value field.
02:01
Now, the visual populates with all the model elements included in the Data Exchange.
02:07
The viewer tools are like those found in the Autodesk Viewer in ACC.
02:11
You can access the Model Browser to review information about the model structure, view Properties of selected elements,
02:17
adjust the viewer Settings, Explode Model, Measure selected elements, or change the view to First Person.
02:25
You can use any of the available visuals included in Power BI to add a data visual to your report.
02:31
First, in the Visualizations pane, ensure that no other visuals are selected, as selecting a new visual will replace the existing one.
02:39
Then, select a visual, such as the Stacked Column Chart.
02:45
Once selected, the visual displays on the report and can be repositioned by dragging and dropping
02:51
or resized using the control grips.
02:54
The Data Exchange used here includes a specific number of curtain wall doors,
02:59
and you want this visual to display the different types of doors and their areas.
03:03
In the Visualizations pane, add specific properties to the relevant fields to display the desired data in the visual.
03:11
In this case, search for and add Type_name to the X-axis field
03:17
and add Area to the Y-axis field.
03:21
In the graph visual, you now see elements with a type name that is blank or undefined, as well as defined element types.
03:30
To refine this view, add Category as a data filter.
03:34
In the Data pane, select Category and drag it into the Filters on this visual group.
03:40
Then, choose the Doors category.
03:44
Now, in the visual, only door types display.
03:48
Click any bar in the chart to highlight elements in the viewer with the same type.
03:53
Click the bar again to remove the highlight.
03:57
Now you can visualize data from a Data Exchange using the Power BI Connector and the visuals included in Power BI.
How to buy
Privacy | Do not sell or share my personal information | Cookie preferences | Report noncompliance | Terms of use | Legal | © 2025 Autodesk Inc. All rights reserved
Sign in for the best experience
Save your progress
Get access to courses
Receive personalized recommendations
May we collect and use your data?
Learn more about the Third Party Services we use and our Privacy Statement.May we collect and use your data to tailor your experience?
Explore the benefits of a customized experience by managing your privacy settings for this site or visit our Privacy Statement to learn more about your options.