The workflow for using Power BI can be divided into the following procedures:
You must install Microsoft Power BI Desktop on your computer. You can download Power BI Desktop from the following Microsoft web site: https://powerbi.microsoft.com
You also must have unrestricted access to all the data (configured in the Security settings in the UC Analytics Admin Setting) that you want to extract. For information about granting access to the UC Analytics data, see the UC Analytics Deployment Guide.
2 |
On the home ribbon, click Get Data. |
• |
• |
• |
• |
• |
3 |
Select the All category which includes all data connection types from all categories. |
5 |
7 |
Click OK. |
TIP: Do not select the Load button at the bottom of the Navigator pane before you have edited your query. If you simply select a table and click Load, all the data in the table is loaded into local RAM on your computer. For example, if you selected EmailMessages and clicked Load, data for every email message stored in UC Analytics would be downloaded to your computer. The download could take a very long time. |
8 |
To edit the query before loading data, select the Edit button. |
For more information about using Power BI Desktop, see the knowledge base at the Microsoft Power BI support site: https://support.powerbi.com/knowledgebase.
1 |
After you have connected to OData and displayed the tables in the Navigator, select EmailMessages and click Edit. |
2 |
In the Query Editor ribbon, click Choose Columns. |
3 |
Clear (Select All Columns). |
4 |
5 |
6 |
Select Date. |
7 |
In the Query Editor ribbon, click Close & Apply. |
To launch the advanced editor, select View from the ribbon and select Advanced Editor. A window appears, showing the existing Query code.
1 |
After you have connected to OData and displayed the tables in the Navigator, right-click EmailMessages and select Advanced Editor. |
Source = OData.Feed("http://MyAnalytics:1336",
EmailMessages_table = Source{[Name="EmailMessages",Signature="table"]}[Data],
#"Removed Other Columns" = Table.SelectColumns(EmailMessages_table,{"Key", "Timestamp"}),
#"Changed Type" = Table.TransformColumnTypes(#"Removed Other Columns",{{"Timestamp", type date}})
3 |
Click Done. |
Source = OData.Feed("http://MyAnalytics:1336",
IsFromExternalToolRequest="true",
StartDate="2019-03-01T00:00:00",
EndDate="2019-03-07T00:00:00"]
EmailMessages_table = Source{[Name="EmailMessages",Signature="table"]}[Data],
#"Removed Other Columns" = Table.SelectColumns(EmailMessages_table,{"Key", "Timestamp"}),
#"Changed Type" = Table.TransformColumnTypes(#"Removed Other Columns",{{"Timestamp", type date}})
After you click Done, the query does not reflect the selected date range. In the Query Editor ribbon, you must click Refresh Preview to preview the data with specified shards. You can click Close & Apply to view the data for the date range from the database.
2 |
Drag the Key and Timestamp fields, listed in the Fields pane, to the Axis and Values labels respectively. |
1 |
After you have connected to OData and displayed the tables in the Navigator, select EmailMessages and EmailMessageParticipants and click Edit. |
2 |
3 |
Clear (Select All Columns). |
4 |
5 |
6 |
Select Date. |
8 |
Clear (Select All Columns). |
9 |
Select Key. |
10 |
11 |
Clear (Select All Columns). |
12 |
13 |
Click the down arrow at the top right of the column header to expand the EmailAddress column. |
14 |
Select DisplayName. |
15 |
16 |
In the Query Editor ribbon, click Close & Apply. |
17 |
2 |
Drag Key and Timestamp fields, listed in the Fields pane, from the EmailMessages entity into the Values and Axis fields respectively. |
3 |
Drag Participant Name field, listed in the Fields pane, from the EmailMessageParticipants entity into the Legend field for the line graph. |
© ALL RIGHTS RESERVED. 利用規約 プライバシー Cookie Preference Center