Sql server data source missing relationships

[kerry]

Hi - wondering if anyone else has encountered this. I use Power Query with a connection to a SQL Server database. We recently updated to SQL Server 2016 and updated our database and since then, when I use Power Query, there seem to be a few relationships missing in the source. Previously each table in the source had some columns at the end that were related and I could expand them to get rows from that table. It all worked great and saved me having to create those relationships. With the new setup, some of the relationships are there, but some of them seem to be missing. When I expand those tables I get what looks like a cross-join and invalid lookups.

Has anyone else encountered this? I don’t really have access to the SQL Server and I ran this by our IT admin and he had no idea what to do.

Thanks,
Kerry