Forum Discussion
Calculated columns were disappeared post data source change
Hi,
I have a Power BI report that connected to the Azure analysis service(data source) in direct query mode(preview). Recently the cube has migrated to a new Azure AS server without any changes in the tabular model.
When I changed the data source(just updated AAS server URL), all calculated columns were removed from the report.
Is this an expected behaviour? Can anyone please help me here?
Regards,
Hari
Are Deployment Pipelines a possibility for you? They are designed to address that exact problem.
6 Replies
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.
Are Deployment Pipelines a possibility for you? They are designed to address that exact problem.