Forum Discussion
DirectQuery issues with Related or Lookupvalue
Hi SevsBo,
Thank you for reaching out to the Microsoft Fabric Community Forum. Thank you johnt75, for your inputs on this issue.
These are known limitations when working in Direct Query mode, especially with cross-table references in calculated columns.
Important Note: Power BI does not support calculated columns that reference values from another table when using Direct Query mode. This is because the expression cannot be fully translated (or "folded") into a single SQL query, and Power BI does not materialize the data locally in this mode.For this reason, functions like RELATED, LOOKUPVALUE, or cross-table logic in calculated columns often fail or throw errors in Direct Query unless both tables come from the same source and the relationships support query folding.
If this helps, please consider giving a Kudos or marking it as Accepted Solution to assist others in the community.Thank you for using the Microsoft Community Forum!
My whole problem is that DirectQuery doesn't allow for that to be done.
And I cannot append data to Table2 that I put in myself as there are more entries per row for same data for Table1 than Table2 so I get an error about multiple entries.
Its meant to be a measure, not a calculated column.