Forum Discussion
Creating relationship between two tables using null calculated columns SSAS
Hi , Anonymous
According to the error message you encountered, you are encountering a problem about data modeling, you have created a many-to-one relationship for two tables in the data model, the link column in dimension table (D) is used as one end column, but the link' column contains duplicate null values, there are two solutions to this error:
The first is to go to Power Query and use filtering to filter out rows in the link column that contain null values and reload them into Power BI
The second is to reconstruct the relationship between the two tables and respecify the primary key associated between the two tables, because as far as I know, if the related primary key between the two tables also contains a null value, it does
It has a certain impact and trouble on data screening and display.
Best Regards,
Aniya Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
Hi , Anonymous
According to the error message you encountered, you are encountering a problem about data modeling, you have created a many-to-one relationship for two tables in the data model, the link column in dimension table (D) is used as one end column, but the link' column contains duplicate null values, there are two solutions to this error:
The first is to go to Power Query and use filtering to filter out rows in the link column that contain null values and reload them into Power BI
The second is to reconstruct the relationship between the two tables and respecify the primary key associated between the two tables, because as far as I know, if the related primary key between the two tables also contains a null value, it does
It has a certain impact and trouble on data screening and display.
Best Regards,
Aniya Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly