Values not found after merge, but if filtered before

[Anonymous]

The following problem: If I merge two tables (left table 1+ right table 2) via left outer join, the merge will not find many values of the attached table 2. (17761 records with unique article ID)
I noticed the following: If I search in the raw table 2 for an (high) article ID that is in table 1, it will not be found at first. But if I set a wider filter in table 2 before, I then find the value in the filter .... and now the value is also found in the merged table.

Can it be that the value without filter is not found in table 2 because a record boundary exists? If so, how can I turn it off?

P.S. If I put it in a table in Power BI Desktop, the will "missing" values are found(?)

[ImkeF]

Not sure I understand your scenario correctly, but you might only see a subset of the results in the query editor, as it limits the rows returned. Always make sure to check your results once they are loaded into the data model.

[Anonymous]

Thanks for your answer Imke! yes, it will show only a section in the query editor, but values that are not displayed but yet "exist" should nevertheless be found in subsequent calculations, right ?

I want to try again to describe it differently: I think it is currently the case that of 17000 rows in table 2 only the top 1000 are displayed. If I now make a merge that requires a value in Table 1 / Row 1 that is in Table 2 on line 1001, it will not be found and it will appear null. But that should not be true!? The value should be found, even if it is not displayed before. So I can not continue working in the query editor, because in the next step I would like to select the "true" nulls. So values that really have no value in Table 2 ... currently there would be nulls, which are actually not nulls.

Incidentally, in the Power BI Desktop, the corresponding values ​​previously specified as null are found..?

Any ideas how I can get the true values in the power query editor?

thank you and kind regards