Power Query Giving Blank Record Warning - There are no Blank Records

[astrodon]

Using Windows 11 Laptop; Excel 365

The two table are in an outside workbook and brought connection only and added to the Data Model. The error states there are blanks in the key data and there are none. What is it really trying to tell me?

I have deleted the tables twice and rebuilt from scratch but keep getting the same error. UGH!

fRawData many side
dDeedRecord one side


TIA

doco

 

[astrodon]

I have discovered the problem although I do not understand why it is happening. Even though the connected table does not have any blank cells in the primary connection fields, somehow when connecting to that back end data, a blank field gets imported to the query. Once discovering this and removing the row, all works well. Inspecting the source does not solve the problem. Inspecting the imported query is where the problem originated. Again, I have not ran into this problem before and cannot explain why Excel insists on embedding an errant row not found anywhere in my source data.

 

[Kerryx]

Thanks for posting the solution