I am having multiple occurances of roughly the same issue with queries that are using Business Central as a data source. Though I don't think the data source is the issue.
I have appended two queries with perfectly matching table structure. Query 1 has 238 rows and Query 2 has 221 rows. So I should get a new query with 459 rows. Instead I either get a query with 476 rows, which consists of Query 1 appended to itself. Or I get a query with 442 rows, which consists of Query 2 appended to itself.
This is strange by itself, but if I refresh the data I get the proper appended query with 459 rows.
But if I take this new appended query and add try to add a merge to it, the merge will always try to be applied to 476 rows. And after the merge, no amount of refreshing will get me a query with 459 rows.
Has anyone else experienced this kind of thing before? What is going on?