Dynamic Text as Title

[migoyafe]

I updated the title of a few columns of a sheet from excel, and the titles in Power BI won't update.The message displayed is the following:
"The column 'Title of the column' of the table wasn't found.'

The data I'm working with in BI, I got from the same Excel document that I changed the title to the columns from.

Note: 'Title of the column' really displays the title of one of the columns whose title I'm trying to update.

[v-yulgu-msft · Accepted solution]

Hi @migoyafe,

Power Query cannot update automatically, it cannot detect the new column name if you change it in source file. That is why such an error "The column 'Title of the column' of the table wasn't found.' is prompted. To resolve it, you have to manually update the column name in Advanced Editor wherever you refer to this column.

Please see below example. 

I loaded a data table from Excel file, added a custom column based on [Column1].

I renamed [Column1] with [ColumnA] in Excel file. Then, click refresh in Power BI desktop.

Locate to Advanced Editor, replace [Column1] with [ColumnA].

Best regards,

Yuliana Gu

[sturlaws]

Hi,

you need edit the query in Power Query. There is a button in the Home ribbon called Edit queries. This button takes you to Power Query. On the right hand side there is panel with the title Applied steps. Either delete all steps except the first one, or change the existing ones to match the new titles of your columns.

If you choose to delete all but the first step, after deleting, click on the remaining step called Source. This will show you a table where the first column is Name and the second is Data. Find the table that contains the data you want in column 1, and on the corresponding line, click on Table in column 2. This will import the data with the new column names.

regards,

Sturla