Forum Discussion
DirectQuery Limitation
Hello,
Could someone please tell me what can I do I need to create a new calculated column in a table with directQuery mode but I can not use (Lookupvalue/Related/Calculatetable......) is there please any solution, or is it impossible to do that!
Thank you.
Hi Rita12 ,
You could use Merge inside Power Query to fetch required value from Master Table,and you can use calculate function with filter function to instead:
Please check https://docs.microsoft.com/en-us/power-bi/desktop-directquery-about 141 to find limitation of Direct Query.
One Limitations in calculated columns: Calculated columns are limited to being intra-row. So, Adding Column using Lookup from other table is not available.
Similar question refer:
https://forum.enterprisedna.co/t/lookupvalue-in-direct-query-calculated-column/4665/2
https://community.powerbi.com/t5/Desktop/DirectQuery-Lookupvalue-function/m-p/714041
Did I answer your question? Mark my post as a solution!
Best RegardsLucien
3 Replies
Hello!
Look at this related answer:
Solved: Re: Can not New Table or use DAX function in Direc... - Microsoft Power BI Community
So what I understand I can not create a new column with a Lookupvalue it's impossible there is no solution, Thank you for yor answer.
- v-luwang-msft
Community Support
Hi Rita12 ,
You could use Merge inside Power Query to fetch required value from Master Table,and you can use calculate function with filter function to instead:
Please check https://docs.microsoft.com/en-us/power-bi/desktop-directquery-about 141 to find limitation of Direct Query.
One Limitations in calculated columns: Calculated columns are limited to being intra-row. So, Adding Column using Lookup from other table is not available.
Similar question refer:
https://forum.enterprisedna.co/t/lookupvalue-in-direct-query-calculated-column/4665/2
https://community.powerbi.com/t5/Desktop/DirectQuery-Lookupvalue-function/m-p/714041
Did I answer your question? Mark my post as a solution!
Best RegardsLucien
