Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Suspected problem with table relationship

I am working on a new Power BI report which is pretty simple, however I believe I am running into a problem with the relationship between two tables.  This is the first time I have experienced this type of issue.  The field I am joining is the order number field in a defects table and a order history table.  The field in both tables is a text field of 8 characters.  I tried duplicating both fields to a whole number and joining those fields instead, but still have the same issue.  Relationship to other tables in the report are working fine.  I can see the proper detail when looking further down either side of this specific join, for example I can see defect subjects, or I can see the employee from the order history.

 

Below are screenshots to help illustrate the setup and issue.  I have a table visulization which shows some fields from the defects side and also lists the order number from the order history table, as you will see the order number is blank.  I have verfied in the data view that this table does indeed have data, and I have a tested simple sql query directly to the database in SQL Server Management Studio which joins the tables properly.  I also provided the model view from Power BI.  If there is any additional data or views I should provide to help diagnose this let me know and I would be happy to provide them.

 

table visualization 

 

model view 

1 Reply

  • the model looks relatively innocent.  maybe provide sample data for the tables that are relevant for recreation of the issue.