Forum Discussion
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 procedur...
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.
Regards,
Xiaoxin Sheng