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 All,
Request help, as the Lookupvalue function is not appearing on connecting power BI with Big Query in the direct query mode.
Please suggest, screenshot attached.
Regards,
Titiksha
Solved! Go to Solution.
I connected to the SQL Server database using Driect query, based on my test, the function LOOKUPVALUES cannot be used in calculated column in this situation.
However, we can go to File -> Options and settings -> Options - > DirectQuery and enable the option “Allow unrestricted measures in Direct Query Mode”.
After that we use the function when we create measures.
You can also check supported functions in DirectQuery mode in this article.
Regards,
Lydia
I connected to the SQL Server database using Driect query, based on my test, the function LOOKUPVALUES cannot be used in calculated column in this situation.
However, we can go to File -> Options and settings -> Options - > DirectQuery and enable the option “Allow unrestricted measures in Direct Query Mode”.
After that we use the function when we create measures.
You can also check supported functions in DirectQuery mode in this article.
Regards,
Lydia
I do not see that option.
I only see the below as the only option....
Hi,
I do not have the option "Allow unrestricted measure in Direct Query"
Where is this options moved in the new version, May 2019 ?
Thanks.
I also do not have the option "Allow unrestricted measure in Direct Query". Is this because my storage mode is mixed? If so, are there any solutions for creating a lookup column? 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 |
---|---|
109 | |
96 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
102 | |
88 | |
63 |