Forum Discussion
Related Not Working in DirectQuery for One to Many Relationship
Hi Anonymous ,
It seems Limited relationships between table1 and table2. Table expansion never occurs for limited relationships. So, you can not use RELATED().
For more details, you can refer these links.
Model relationships in Power BI Desktop - Power BI | Microsoft Docs
RELATED function (DAX) - DAX | Microsoft Docs
Best Regards
Community Support Team _ chenwu zhu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
amitchandak I appreciate it, but your video does not help. My question is related to DirectQuery across two different databases, and your video is all from the same database with the exception of the import table.
My issue is: Table 1 is in DB_1. Table 2 is in DB_2. Both are Direct Query. I cannot use RELATED because they are in different DBs (same server). Even if I create a view of Table 2 in DB_1, it will not work.
Hi Anonymous ,
It seems Limited relationships between table1 and table2. Table expansion never occurs for limited relationships. So, you can not use RELATED().
For more details, you can refer these links.
Model relationships in Power BI Desktop - Power BI | Microsoft Docs
RELATED function (DAX) - DAX | Microsoft Docs
Best Regards
Community Support Team _ chenwu zhu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.