Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Data refresh gives an error "Column not found"

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 transfor...
data protection
  • Anonymous's avatar
    Anonymous
    4 years ago

    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.

Anonymous's avatar
Anonymous
Not applicable
4 years ago

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.