Forum Discussion

migoyafe's avatar
migoyafe
Regular Visitor
7 years ago
Solved

Dynamic Text as Title

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 foun...
Need Help
  • v-yulgu-msft's avatar
    v-yulgu-msft
    7 years ago

    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's avatar
sturlaws
Resident Rockstar
7 years ago

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