Forum Discussion
Helper IIDataflow Column Name Change, Will it break downstream queries
Hi community,
Will changing a dataflow column name break downstream power queries? I want to change the name of a column in a dataflow but I am worried that if I change the name in the dataflow then everything that was referencing that column in a query will break. I am wondering if behind the scenes some type of temporal table is storing column names historically so you can change names without breaking everything.
Best!
Yes, it will most likely break the downstream datasets and reports. There are small remedies like using Table.SelectColumns instead of Table.RemoveColumns or use the [Column]? construct. But eventually you will have to manually refresh the impacted reports to re-sync the meta data, and then update the app as well.
1 Reply
- lbendlin
Super User
Yes, it will most likely break the downstream datasets and reports. There are small remedies like using Table.SelectColumns instead of Table.RemoveColumns or use the [Column]? construct. But eventually you will have to manually refresh the impacted reports to re-sync the meta data, and then update the app as well.