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!
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!
Hi SevsBo,
May I ask if you have resolved this issue? If so, please mark the helpful reply and accept it as the solution. This will be helpful for other community members who have similar problems to solve it faster.
Thank you.