Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Script Relationships Auto create relationships Tabular Model

I would like to create ALL relationships in one attempt (not one by one) for the tables imported into my tabular model using Visual Studio.

 

I have renamed the relationship keys in my dimension and fact tables to be able to automatically match ( eg DIM_Time[TimeID] > FACT[TimeID] ).

 

I am aware that the auto creation works when you do this in Power BI Desktop, but I am using a tabular model.

 

 

  • Anonymous's avatar
    Anonymous
    3 years ago

    HI Anonymous,

    I think these were power bi only features which not also released to tabular model. Perhaps you can import the data model to power bi side for analysis and then you can connect to the power bi data model instance to export the relationship mappings.

    Power bi data model instance 

    Regards,

    Xiaoxin Sheng

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable

    HI Anonymous,

    I think these were power bi only features which not also released to tabular model. Perhaps you can import the data model to power bi side for analysis and then you can connect to the power bi data model instance to export the relationship mappings.

    Power bi data model instance 

    Regards,

    Xiaoxin Sheng