Data refresh gives an error "Column not found"

[Anonymous]

Hello all, I have a data source connected to PowerBI which data is being updated each month.The data is in wide format with column headers that are dates  in the format "dd/mm/yyyy''.I apply transformation steps such as transforming the data from wide to long format.However,these column headers are changing every month with new dates ,which causes the query to breaks since the column headers initially imported are not existing anymore.Any ideas how to solve this?Any help will be greatly appreciated.Thanks in advance.

[Anonymous · Accepted solution]

Hi @Anonymous ,

It's a common error when you try to reference a column that existed before but no longer exists after the data refresh.

I think it's not possible to dynamically change a transformation already applied in Power Query based on a data refresh. For example:

So you need to modify it manually.

It's also explainned in the Microsoft documentation  ——

Best Regards,
Eyelyn Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.