Forum Discussion
Dynamic Text as Title
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
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