RELATED do not work with SQL direct query

[steffens12]

Hi together,

I have a few databases on sql servers which a get in powerbi via direct query. I created relationships between the datasources and not want to add new columns using the RELATED command. I always get an error that there is no realtionship or the column which i would to take is not availible. But both failures do not exist. The column is there and i choose it from the suggestions which powerbi makes when i search for it and the relationship is also there. I must go via direct query and not import cause the files are too big. 
It it possible that RELATED do not work with SQL Servers as sources via direct query?

Thanks a lot for your help.

[Anonymous]

Hi @steffens12 ,

Based on the description, RELATED is supported in DirectQuery. RELATED function can not be used to fetch a column across a limited relationship.

You can also view the following documents to learn more information.

RELATED function (DAX) - DAX | Microsoft Learn

Solved: Direct Query - related function - Microsoft Fabric Community
Model relationships in Power BI Desktop - Power BI | Microsoft Learn

Best Regards,

Wisdom Wu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@steffens12 , Related only works for one to many relation, when you create a column in Many side table taking value from one side table.