Forum Discussion
Data 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
Ehren wrote:Hi edhans. This issue has now been fixed in the Power BI service, but the gateway update will be coming in the next day or two. I will email you a private link so you can download the new gateway before it's officially released.
Ehren
I think there may be an issue with the November gateway or service Ehren
I have kept my report running that does the same sales table 3 ways:
- Table.Combine()
- Table.Buffer before doing the Table.Combine()
- UNION() measure in DAX
Last night, #2 reported different results. Thousands of dollars. The report that is running has not been updated with the desktop in months, but I did just install the Nov gateway yesterday morning.