Forum Discussion
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.
1 Reply
- lbendlinSuper User
the model looks relatively innocent. maybe provide sample data for the tables that are relevant for recreation of the issue.