Relation is not recognized

[EwoutVlugNL]

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. 

[Anonymous · Accepted solution]

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.

[EwoutVlugNL]

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.