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.
Advocate III see this issue as well. I have data in the PBIX dataset and then I am trying to use Reference data that is in a DataFlow, and trying to use direct query so that I can update the reference and the report will show new info (hopefully!).
Related did not work, despite being able to make the relationship.
LookUpValue seems to be working.