Forum Discussion
Import data from SSAS Tabular model into PowerBI
Hi, We've bulit a main Tabular model in SSAS but our end user would like to have the ability to add more adhoc dimensions per their own need, so we really need to import the Tabular model into Po...
Loading table seperately doesn't solve the problem because after the table loading, I can't recreate the relations. It keeps telling me need unique value to establish the relationship where I know the value in the table is unique.
I have noticed that it adds a Null row on import which violates the uniqueness check when creating relationships. If you filter the NULL/Blank row for the primary key table in the editor it will allow the join.
Despite that workaround, I am very confused as to why the Import mode would not utilize the relationships defined in the model to create result sets consistent with a live connection.