Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
hi,
is LOOKUPVALUE not supported in Direct Query ?
I have two table (from SQL Direct query) which both no relationship.
But I want to get the value from table A to table B.
I try to add calculated column in table B, but there is no such funtion if looking at intelisense.
Thanks,
Hi,
For unknown reason, I cannot put relationship to that table, everytime my Power BI freeze.
FYI, the table I wan to to relate (or the loookup table) is having a binary column (it's a jpeg file), would that be a problem ?
I also get the data not in the "normal way", because somehow I need to run a query in the M language, because I need to convert the binary column from SQL server to text during the catch, like this :
Suspected this is also the cause it is freeze when I want to put relationship to other table. Hence I decided not to put a relationship but use LOOKUPVALUE function.
thanks.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
108 | |
100 | |
78 | |
64 | |
58 |
User | Count |
---|---|
148 | |
111 | |
94 | |
84 | |
67 |