Forum Discussion
RELATED do not work with SQL direct query
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.
2 Replies
steffens12 , Related only works for one to many relation, when you create a column in Many side table taking value from one side table.
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 LearnBest Regards,
Wisdom Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
