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.
