ALM Toolkit - Failed to save modifications to the server

[AmudhaKumaran]

Hello Everyone,

Came across something in ALM toolkit today. Just wanted to share this. Maybe someone would find it useful.

I have a PBI dataset with few tables. Tried to add a new table to the model. While I was trying to push changes using ALM toolkit, got an error  -"Failed to save modification to the server - Key didn't match any record in the table". I have already seen this error in Power Query when there is invalid data. But saw it for the first time in ALM toolkit. 

While troubleshhoting, found one table in the dataset with duplicate values in primary key column. Though it had nothing to do with the new table that will be added, ALM threw this error as it compared the whole dataset.

Removed duplicates in the affected table and pushed the new table to model again which actually worked.

Thanks

@AmudhaKumaran

[Anonymous]

Hi @AmudhaKumaran ,

Thank you for sharing, I think this is useful. More people will benefit.😀

Best Regards,

Stephen Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.