Forum Discussion
Maintain Original Column Name in Report Builder Table
Hi RPYee , hello rohit1991, thank you for your prompt reply!
As far as I know, there is no way to change this default behaviour.As a workaround, we could set expression for each column, double click the filed you need to make it display underscore:
Additionally, you could also save the file first, then open the file in notepad, replace the column name in text editor:
Best regards,
Joyce
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Super UserTo maintain original column titles with underscores in Power BI Report Builder:
- Manually Edit Header Text: Click on the header cell and type the original name (e.g., entry_nbr).
- Check Dataset Query: Ensure column aliases in the query match the original names with underscores.
- Disable Auto Formatting: In the header cell properties, set Value to the exact column name (e.g., [entry_nbr]).
Preview the report to confirm changes.
1. There are about 30 columns being pulled. I do not have the time, nor the patience, to manually edit every single column header. With a program as robust as PowerBI, I shouldn't have to!
2. Even when my query plainly states AS, with the underscore included, the underscore is being removed from the column header.
3. I cannot find this setting. Can you provide a bit more detail on where it is located?
Hi RPYee , hello rohit1991, thank you for your prompt reply!
As far as I know, there is no way to change this default behaviour.As a workaround, we could set expression for each column, double click the filed you need to make it display underscore:
Additionally, you could also save the file first, then open the file in notepad, replace the column name in text editor:
Best regards,
Joyce
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.