cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
SeanHenderson Regular Visitor
Regular Visitor

Merge Query Breaking Appended Query

Hi,

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?

1 ACCEPTED SOLUTION

Accepted Solutions
SeanHenderson Regular Visitor
Regular Visitor

Re: Merge Query Breaking Appended Query

For those interested, the issue appears to be due to the fact that the default operation that a Merge does is a nested query.

3 REPLIES 3
CloudMonkey Member
Member

Re: Merge Query Breaking Appended Query

Please can you attach the pbix file or share by https://uploadfiles.io/ for example?

 

Thanks,

 

CM

SeanHenderson Regular Visitor
Regular Visitor

Re: Merge Query Breaking Appended Query

The pbix contains very sensitive client information and cannot be shared.

SeanHenderson Regular Visitor
Regular Visitor

Re: Merge Query Breaking Appended Query

For those interested, the issue appears to be due to the fact that the default operation that a Merge does is a nested query.

Helpful resources

Announcements
Back to School Contest

Back to School Contest

Engage and empower students with Power BI!

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Summit Australia 2019

Summit Australia 2019

Travel to Melbourne and network with thousands of peers!

Top Ideas
Users Online
Currently online: 279 members 3,045 guests
Please welcome our newest community members: