How to rename the column name

Like (0) Share

Report

Posted on 23 Feb 2024 10:38:38 by Tracy000

Hi team,

One problem would like to ask for your kind suggestion, thanks in advance.

I have a flow to get the data from power bi dataset and then write the result into a sharepoint file.

After step run a query against dataset, I want to rename the column name and then write to sharepint file.
But currently the rename function doesn't work, could you please kindly advise?

Part of Flow step:

I use this for Map item() -> item()?['FINAL_MASTER_INT_DEL[Intervention_Del]']

Run a query against dataset: summarizecolumns
"Intervention_Del", IGNORE('FINAL_MASTER_INT_DEL'[Intervention_Del]),
"Sumdata", IGNORE(CALCULATE(SUM('sys_wty_finalflash'[data]))),
......

......

Result:

I want to change the first [Intervention_Del] to Warranty, but I got the null result.

All responses (2)

Answers (1)

Tracy000 10 on 26 Feb 2024 at 01:17:24

Like (0)

Report

Re: How to rename the column name

It works, many thanks!
Verified answer

lbendlin 7,914 Super User 2025 Season 1 on 23 Feb 2024 at 18:20:21

Like (1)

Report
Re: How to rename the column name

I use this for Map item() -> item()?['FINAL_MASTER_INT_DEL[Intervention_Del]']

use item()?['[Intervention_Del]']