I want to modify the header when adding data

If you change the query like the following capture, you will get an error message. I want to modify the header when adding data, but an error will occur. Please tell me how to resolve.

As a procedure,① Edit query② Add query as new query③ Header in the main table: Specify data in the table to be added to the main table④ Select all newly created queries and change the data type to text⑤ Use the first line as the header, and apply it.

Re: I want to modify the header when adding data

Based on error message, you are try to add additional steps at direct query mode, right?If this is a case, current power bi not support these operations in 'direct query' mode.(calculate on row contents, summary/group rows, add new columns...)

For your scenario, I'd like to suggest you to switch to import mode and try again.

Regards,

Xiaoxin Sheng

Community Support Team _ XiaoxinIf this post helps, please consider Accept it as the solution to help the other members find it more quickly.