Visualize data from a data exchange using the Power BI Connector and the visuals included in Power BI.
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.
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.
