The column either doesn't exist or doesn't have a relationship to a table available

[Sreerams26]

This is a frequent issue that is raised in the forum but the solution is not applicable in my case.

I have two tables 1. Directquery from SQL database and 2. sharepoint. There is one to many relation as shown in the image below.  I need to pull the "To unit value" column to calculate the qty in KG in my prod table.

I created a calculated column and the result is as below.

I also tried to create a measure using the DAX 

Measure = SUMX(Productioncalctrans,Productioncalctrans[REALQTY]*RELATED('Unit Conversion'[to unit value])) and I get the same error.

I have not been successful with related function while I am using direct query.  When I convert the table to import table, then the related function is working.

pllzzzz help.  this function is bothering me and forcing me to jump to import mode making my database size huge.

[v-yangliu-msft]

Hi  @Sreerams26 ,

You can check the following link about the limitations related to the RELATED() function to check whether your table-to-table relationship is a limited relationship.

RELATED function (DAX) - DAX | Microsoft Learn

The RELATED function cannot be used to fetch a column across a limited relationship.

In direct query mode, modeling has some limitations：

Solved: The column x either doesn't exist or doesn't have ... - Microsoft Fabric Community

This is the related document, you can view this content:

Solved: Related function not working with Mixed Mode - Microsoft Fabric Community

Solved: Direct Query - related function - Microsoft Fabric Community

Using RELATED and RELATEDTABLE in DAX - SQLBI

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.

[Sreerams26]

Thanks for the references.  but none of that helps.

"RELATED function (DAX) - DAX | Microsoft Learn

The RELATED function cannot be used to fetch a column across a limited relationship."  Mine is not a limited relation.  

"In direct query mode, modeling has some limitations：

Solved: The column x either doesn't exist or doesn't have ... - Microsoft Fabric Community"

If I merge queries, it is suggesting me to convert it to import mode to finish the merge function

I also went throuth the other solutions before posting mine here.  None of the solutions is working for me.