Forum Discussion
Community ChampionData Model in Service duplicating and replacing rows
Hi Ed. As I said over email, we've identified the root cause of this issue. We're currently targeting the fix for our July release.
In the meantime, you can work around the issue by ensuring that your folded queries are always sorted. This can be done by always including (and preserving in downstream queries) all primary keys for a given table. Or, if this isn't possible (as in your case when doing a Group By operation), you can explicitly sort by a set of unique keys before combining. (Also note that it may be necessary to buffer after sorting and before combining to ensure the sort is applied by the folding layer. You'll have to experiment to see whether or not this is necessary.)
Ehren
Community ChampionHoping the team got in touch with you Ehren. Spent nearly an hour convincing them it wasn't the workspace, my browser, and renaming and republishing the report also wasn't the fix.
Honestly, if you need me to dump these tables into a different database so you can restore it into SQL 2008 let me know.
Microsoft EmployeeI haven't seen anything. Can you please point them to this thread and ask them to add me to the email thread with you? I've met with two other customers who are experiencing this and would like to live debug some things with you.
Ehren