Error due to "missing" relationship in a DAX when I switched to Direct Query

[alianazambori]

Hi

I converted a PBI report from import to Direct Query to a SQL Server. All the relationships between tables are identical in Import and DQ mode. The same DAX function in DQ has an error: The column CURVE_PROPERTY[Update Owner] either doesn't exist or doesn't have a relationship to any table available in the current context.

The relationship in all 3 tables is based on CurveId column

How can I solve this issue?

Thank you

[James-Harpin]

Hello,

Try changing the relationship to BI-directional.

James