Forum Discussion
change column heading
I assume you are speaking about the Table visualization in the report section.. You can't change the name of a column within a visual.
You need to change the name of the field you are using in the data set. You can't have column1 be customized for every visualization, it's column 1 in everything...
You can do this in various places.
Report View - Right click the field in the field list, Rename
right click the column
Data View - Right click in the field list like above, or right click the column name on the table.
I assume you are speaking about the Table visualization in the report section.. You can't change the name of a column within a visual.
You need to change the name of the field you are using in the data set. You can't have column1 be customized for every visualization, it's column 1 in everything...
You can do this in various places.
Report View - Right click the field in the field list, Rename
right click the column
Data View - Right click in the field list like above, or right click the column name on the table.
Hi
I am using a Tabular data source with Power BI, but cannot locate where to change the field name, i.e. alias it.
I assume you can do this in the browser as well as dekstop version .
However I must be missing something obvious.
Any help appreciated.
Cheers
Andrew
Andrew_OCP, are you using a live connection to Tabular with the Enterprise Gateway, or are you using an imported data model?
If you are using a live connection, Power BI only offers the functionality of Power View, the reporting and visualization layer. All metadata is stored in SSAS, and column name changes would have to be initiated in the SSAS model.
If you are using an imported data model, you can change your field names in the Power Query section of Power BI (Edit Queries ribbon menu item).
Regardless of the dataset type, none of these changes can be made in Power BI Service. Data model manipulation is only available in Power BI Desktop. Power BI Service is a consumption and lightweight report authoring environment.
SSAS modifications would be made through SSDT.
Do you think there will be support in updating field names on a per-use basis like is currently possible in Excel connected to a live SSAS tabular model?
In response to your comment, "If you are using a live connection, Power BI only offers the functionality of Power View, the reporting and visualization layer. All metadata is stored in SSAS, and column name changes would have to be initiated in the SSAS model."
Is there a way to change the name in the SSAS model and have that change carry through into the reporting and visualization layer? I have multiple people with ready made dashboards and when I attempt to change a column header, the old header already in their report does not automatically update to the new column header name. Therefore, it is doesn't seem feasible to change headers in the SSAS because I would create errors in all of their reports and they would have to replace each old header the the new one.
