Forum Discussion
Calculated columns were disappeared post data source change
Are Deployment Pipelines a possibility for you? They are designed to address that exact problem.
Kinda sorta. Usually when you change a data source query but keep the physical data source location and all columns as is then you get away with it. But the moment you change the physical data source this is considered too much of a meta data change, and calculated columns, measures, relationships etc. will disappear.
Assuming you have made a backup of your pbix before the change you can recreate the items that were dropped by opening that version side by side with the new one.
Thanks for your input.
Yes. I have the backup of pbix using which I have recreated all the calculated columns. No issue with the measures I have created them under a separate table.
During a project, the cube keeps migrated from the dev environment to the test, then test to the production environment. All this time recreating calculated columns is an additional effort. I was looking for a permanent solution for this.