DB Query result is different to Power Query result and SQL Server Management Studio

I need to compare results between 2 Databases with exact same table layout.

Microsoft SQL Server 1 with Database 1 and Table1 and then Microsoft SQL Server 2 with Database 1 and Table 1. Linked to the is a DB Query reader with the same SQL Query. When I run the results of Query for MS SQL Server2 is same as for MS SQL Server 1, but they should be different.

What can I check to make sure thye are referring to different databases?