Forum Discussion
Solved
Trouble with LOOKUPVALUE() in DirectQuery: Need Guidance on Calculated Tables and Refresh Failures P
Hello everyone, I need help solving an issue with PowerBI. I connected to a PowerBI dataset using 'DirectQuery' and realized that the LOOKUPVALUE() function is not allowed with tables in 'Direct...
Pjutgg , In Direct query you have limitations on what you can use column/measures, Especially columns.
Across tables, you are only allowed to use DAX function Related. Rest you are not.
Direct Query - End to End (Connection to Publish): https://youtu.be/cf-YNWX8Qow
amitchandak
Super User
Super UserPjutgg , In Direct query you have limitations on what you can use column/measures, Especially columns.
Across tables, you are only allowed to use DAX function Related. Rest you are not.
Direct Query - End to End (Connection to Publish): https://youtu.be/cf-YNWX8Qow
Hey Amitchandak,
Thanks for your help. I will check that right now 🙂