Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
Import weekly metrics and attribute data from Workplace Analytics.
Summary
| Property | Value |
|---|---|
| Connector |  Viva Insights |
| Products | Power BI (semantic models) Power Query Online |
| Release state | General availability |
| Category | Online Services |
| Authentication kinds | Organizational Account |
| Data source kind | VivaInsights |
| Function Reference Documentation | VivaInsights.Data |
Supported capabilities
Entry point: VivaInsights.Data
Parameters
Entry point: VivaInsights.Data
Required parameter count: 1
Import weekly metrics and attribute data from Workplace Analytics.
| Parameter | Display name | Required | Type | Group | Description | Sample values | Nullable | Additional metadata |
|---|---|---|---|---|---|---|---|---|
| scopeId | Partition Identifier | Yes | text | In the advanced insights app, go to Analysis > Query results, find your query, and select Link to get the partition identifier. | "5f142ea5-c08a-eb02-de68-41dccdefb141" | false | ||
| jobName | Query Name | No | nullable text | Input the query name as it is found on the Analysis > Query results page in the advanced insights app. | "Contoso's Person Metrics" | true | ||
| jobId | Query Identifiers | No | nullable text | In the advanced insights app, go to Analysis > Query results, find your query, and select Link to get the query identifier. | "ad4052e-0925-4b2e-99be-62789d4227ff" | true | {"Formatting.IsMultiLine": true} | |
| options | Advanced options | No | nullable record | Advanced options | true |
Fields in options
| Field | Display name | Required | Type | Group | Description | Allowed values | Sample values | Nullable | Optional | Declared allowed values |
|---|---|---|---|---|---|---|---|---|---|---|
| options.SchemaType | Schema type | No | text | Advanced options | Select Pivoted to load organizational attributes as individual columns or Unpivoted to load organizational attributes as key-value pairs, such as Attribute name = Organization, Attribute value = Finance. | "Pivoted" | false | true | ["Pivoted"] | |
| options.TableName | Table name | No | text | Advanced options | If the Advanced insights query outputs more than one table, specify which table to connect to. | "surveyData" | false | true |