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 comma...
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.