Forum Discussion

MontherKH's avatar
MontherKH
Frequent Visitor
1 year ago

SSAS Tabular Model Date Relationship Does Not Work For Some tables in Power BI

I have created SSAS Tabular Model, in this model there is a date dimension table.

 

After connecting to the model in Power BI, I am facing a problem that the Date relationship is working for some tables, but not for others.

 

I have made sure that the relationship is created on the correct fields, ensured that the relationship fields from both sides are of data type (Date) with the same format (M/d/yyyy), and all relationships are active.

 

I have also made sure that there are no slicers or filters affecting the behavior.

 

Below you can see a highlight of 2 tables, one of them works as intended with the date dimension, while the other doesn't.

 

 

The yellow outline shows the date dimension, the green outline shows a table that works successfully with the date dimension, the red outline shows a table that does not work with the date dimension.

 

Below you can see the result when I create 2 tables in Power BI with 2 columns, the year column from the date dimension, and a numerical value from the highlighted tables.

 

 

As you can see, the relationship works for the second one, but not for the first one.

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable

    Remove the relationship between the RenewRenewRequest and the PR_RenewRequestPA.. and see if it works then. 

    If it does, there is confusion between the date dimension and the 2 tables(queries) because of the extra relationship.