Activity log columns

Every column of activity_log_data_v1, in the order Power BI shows them.

Turn on Diaries & activities to read this table. Money columns are blank unless the connection’s Prices switch is on.

Rows come in report order within each date range. Empty values are blank. Lacroo_Row_Key is unique in one refresh; it is not a record id.

Refresh in full. Leave Incremental refresh off so every change, including to older records, comes through.

#	Column	Power BI name	Type	Core type	Differs from Core
1	`Activity Description`	`Activity_Description`	Text	text
2	`Actual Cost`	`Actual_Cost`	Decimal number	number
3	`Actual Qty`	`Actual_Qty`	Decimal number	number
4	`Cost Code`	`Cost_Code`	Text	text
5	`Cost Rate Variance`	`Cost_Rate_Variance`	Decimal number	number
6	`Diary Date`	`Diary_Date`	Text	text	DD/MM/YYYY text, as Core’s function gives it.
7	`Program Code`	`Program_Code`	Text	text
8	`Project`	`Project`	Text	text
9	`Project Code`	`Project_Code`	Text	text	The project’s live stage contract numbers, joined with commas, as the Workforce Log prints them.
10	`Project Company ID`	`Project_Company_ID`	Text	text	The project’s stage company ids, joined with commas, as the Workforce Log prints them.
11	`Qty Variance (A-T)`	`Qty_Variance_A_T`	Decimal number	number
12	`Sub Code`	`Sub_Code`	Text	text
13	`Supervisor`	`Supervisor`	Text	text
14	`Target Cost Rate`	`Target_Cost_Rate`	Decimal number	number
15	`Target Cost Rate Unit`	`Target_Cost_Rate_Unit`	Text	text
16	`Target Qty`	`Target_Qty`	Decimal number	number
17	`Target Qty Unit`	`Target_Qty_Unit`	Text	text
18	—	`Report_Date`	Date	—
19	—	`Lacroo_Project_ID`	Text	—
20	—	`Lacroo_Row_Key`	Text	—

Keep your Core column names

Add this step in Power Query’s Advanced Editor after the source step, so reports built on the Core names keep working.

Renamed = Table.RenameColumns(Source, {
    {"Activity_Description", "Activity Description"},
    {"Actual_Cost", "Actual Cost"},
    {"Actual_Qty", "Actual Qty"},
    {"Cost_Code", "Cost Code"},
    {"Cost_Rate_Variance", "Cost Rate Variance"},
    {"Diary_Date", "Diary Date"},
    {"Program_Code", "Program Code"},
    {"Project_Code", "Project Code"},
    {"Project_Company_ID", "Project Company ID"},
    {"Qty_Variance_A_T", "Qty Variance (A-T)"},
    {"Sub_Code", "Sub Code"},
    {"Target_Cost_Rate", "Target Cost Rate"},
    {"Target_Cost_Rate_Unit", "Target Cost Rate Unit"},
    {"Target_Qty", "Target Qty"},
    {"Target_Qty_Unit", "Target Qty Unit"}
})

Combined report columns Report tables