Global Renaming of Column Headers to show the Table (data source) name

[AaronMichels]

Hi, new power BI user here.

I've got a bunch of tables that have very similar data in them that I'm looking at together.  So I have a bunch of columns with the same header name. When I start pulling fields into visualizations, the source of the data thus gets confused. Is there a way to globally rename all of the column headers so that instead of fields being named:

Column 1, Column 1, Column 1, ...

I can see Column headers named as:

Table 1 Column 1, Table 2 Column 1, Table 3 Column 1, ...

Thanks!

[tjd · Accepted solution]

Yes.  The manual way would be to go to the data view and right-click each column header and select "Rename".  The quicker, and more efficient way is to do it via your data input query.

[tjd · Accepted solution]

Yes.  The manual way would be to go to the data view and right-click each column header and select "Rename".  The quicker, and more efficient way is to do it via your data input query.

[tjd · Accepted solution]

You might want to view this YouTube video on how to do this: Add prefix to headers in Power Query #1: Cleaning Data with M

[AaronMichels]

Thanks! super helpful.