SSAS Tabular Model - Multiple Relationship between the Objects

Santosh Kumar 61 Reputation points

Hi Friends,

In SSAS Tabular Model, i have 2 objects. We need to setup a relationship between these objects 2 times based on the surrogate key in order to get the Date related fields from the Date Dimension Table.

  1. Account Fact Table
  2. Date Dimension Table


Datekey - StartDateKey
Datekey - EndDatekey

But I was getting below error while trying to create a 2nd relationship.

Can you please help me on this issue.

Thanks in advance.

SQL Server Analysis Services
SQL Server Analysis Services
A Microsoft online analytical data engine used in decision support and business analytics, providing the analytical data for business reports and client applications such as Power BI, Excel, Reporting Services reports, and other data visualization tools.
1,258 questions
{count} votes

Accepted answer
  1. CarrinWu-MSFT 6,866 Reputation points

    Hi @Santosh Kumar ,

    Thanks for your posting.

    In SSAS tabular model, you can only have one physical relationship between two tables active at a time. It depends on how the end user wants to interact with the data but one option is to duplicate your master table. You could set one relationship to inactive. For more information, please refer to Requirements for relationships.


    Best regards,

    If the answer is helpful, please click "Accept Answer" and upvote it.
    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

    0 comments No comments

0 additional answers

Sort by: Most helpful