Showing results for 
Search instead for 
Did you mean: 
Frequent Visitor

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.

Thank you.



Community Support
Community Support

Re: I want to modify the header when adding data

Hi @sachiko,


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.



Xiaoxin Sheng

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

Helpful resources

Announcing the New Spanish Forum

Announcing the New Spanish Forum

Do you need help in Spanish? Check out our new Spanish community section.

MBAS Gallery 2020

MBAS Gallery 2020

Watch Microsoft Business Applications Summit sessions on-demand.

‘Better Together’ Integration Forum Launch

‘Better Together’ Integration Forum Launch

We've launched a how-to forum where you can learn about how Power BI integrates with other Power Platform products.

Top Solution Authors
Top Kudoed Authors