Forum Discussion

TitikshaGanjoo's avatar
TitikshaGanjoo
Frequent Visitor
8 years ago
Solved

Lookupvalue function not appearing - Direct Query mode

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...
Need Help
  • Anonymous's avatar
    Anonymous
    8 years ago

    TitikshaGanjoo,

    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

Anonymous's avatar
Anonymous
Not applicable
8 years ago

TitikshaGanjoo,

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

Shashanth's avatar
Shashanth
Frequent Visitor
5 years ago

I do not see that option.

I only see the below as the only option....