Import Mode - can I reshape/add columns to the data without it breaking?

[CharlotteB]

Hello,

I'm using import mode for my reports and keep getting this error when a field is added to the dataset. I added a new column in SQL to the dataset vPIT_LoanMM (see the below picture). Is there any way to fix this without deleting the dataset and adding it back in? Thank you in advance. 

[aj1973]

Hi @CharlotteB 

Adding a new column in SQL server does not break the load/refresh of your Model. Other changes may have been applied that caused it, like name of fields, relationships between tables like having a 1 to many joins and fater the change it became many to many....

You need to detect where the change had occured