Forum Discussion
Relation is not recognized
Hi,
In my datamodel it is unable to link (GLACCOUNT - ID) to Trancastion - GLACCOUNT.
Tried the following steps:
- remove duplicated on the GL ACCOUNT ID
- both text
- filterd out empty cells on the GL ACCOUNT ID
How to fix this? Attached the photos that is a one to many relations with no errors.
Hi EwoutVlugNL ,
Are you referring to the fact that power bi desktop does not automatically load the relationships between two tables?
You can check if the option “Import relationships from data sources on first load” is turned on in File > Options and settings > Options.
This option is selected by default. When it's selected, Power BI checks for relationships defined in your data source, such as foreign key/primary key relationships in your data warehouse. If such relationships exist, they're mirrored into the Power BI data model when you initially load data. This option enables you to quickly begin working with your model, rather than requiring you find or define those relationships yourself.
This is the related document, you can view this content:
Create and manage relationships in Power BI Desktop - Power BI | Microsoft Learn
Relationship troubleshooting guidance - Power BI | Microsoft Learn
Best Regards,
Liu Yang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
2 Replies
Hi EwoutVlugNL ,
Are you referring to the fact that power bi desktop does not automatically load the relationships between two tables?
You can check if the option “Import relationships from data sources on first load” is turned on in File > Options and settings > Options.
This option is selected by default. When it's selected, Power BI checks for relationships defined in your data source, such as foreign key/primary key relationships in your data warehouse. If such relationships exist, they're mirrored into the Power BI data model when you initially load data. This option enables you to quickly begin working with your model, rather than requiring you find or define those relationships yourself.
This is the related document, you can view this content:
Create and manage relationships in Power BI Desktop - Power BI | Microsoft Learn
Relationship troubleshooting guidance - Power BI | Microsoft Learn
Best Regards,
Liu Yang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi, no my question not relate the automatically relations connection, but the relations is not set up/not recognized at all.
there is no relation established when viewing the datamodel. I have cleaned en trimmed the columns on both side but that didn't help.
