WorkplaceAnalytics.Data

WorkplaceAnalytics.Data is a Power Query M function that imports weekly metrics and attribute data from Workplace Analytics.

Compatible with: Power BI Service Power BI Desktop Excel Microsoft 365

Syntax

WorkplaceAnalytics.Data(
   scopeId as text,
   optional jobName as nullable text,
   optional jobId as nullable text,
   optional schemaType as nullable text,
) as table

Description

Import weekly metrics and attribute data from Workplace Analytics.

Examples

Returns a table with visible attributes and per week metrics for each measured employee in the partition.

// Output: #table( {"Query1"}, {{"PersonId""}, {"PID"}} )
VivaInsights.Data( "5f142ea5-c08a-eb02-de68-41dccdefb141" )

Other functions related to WorkplaceAnalytics.Data are:

BI Gorilla Blog

Last update: August 25, 2023 | Contribute » | Contributors: Rick de Groot
© 2023 BI Gorilla. All rights reserved. Content derived from Microsoft documentation is property of Microsoft Corp.