cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
HariharanS
Frequent Visitor

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

1 ACCEPTED SOLUTION
lbendlin
Super User
Super User

Are Deployment Pipelines a possibility for you?  They are designed to address that exact problem.

View solution in original post

6 REPLIES 6
gdarakji
Resolver III
Resolver III

The calculated columns are created in the PBIX? Why don't you create them in the AAS model. This way, they will become part of the model and won't disappear no matter what you do

I have created around 8 calculated columns in pbix .Simpe Dax funtions!

lbendlin
Super User
Super User

Are Deployment Pipelines a possibility for you?  They are designed to address that exact problem.

View solution in original post

Yes. Right now I dont have one. Using a single workspace.

lbendlin
Super User
Super User

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.

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Power BI October Update 2021.jpg

Power BI Release

Click here to read more about the October 2021 Release!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Teds Dev Camp Oct. 2021 768x460.jpg

Power BI Dev Camp - October 28th, 2021

Mark your calendars and join us for our next Power BI Dev Camp!