Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
107 | |
98 | |
77 | |
66 | |
53 |
User | Count |
---|---|
144 | |
104 | |
100 | |
86 | |
64 |