I have a very simple inner join connecting an excel file in storage, to a view in a database. The join is on a reference that exists in both data sets. However there are no results.

The schema for both data sets has been imported correctly and matches on data types.

This is a test scenario, the data in the excel file is a simple export from the view, therefore every row should in theory match.

I expect to see a 100% match for the excel file, as the rows that exist within it, were copied directly from the view which it is now being joined to.