Forum Discussion

Joerobert's avatar
Joerobert
Advocate V
8 years ago
Solved

Caculate, Filter Agrument is CAPS sensitive

Why is the filter argumenets in the calculate function CAPS sensitive? see below screenshots as reference showing identifical expressions with the logical statement changed to lowercase.   ...
Show and Tell
  • Anonymous's avatar
    Anonymous
    8 years ago

    Joerobert,

    In my first reply, I am using SQL Server data source.

    I test the connection to Oracle in April update of Power BI Desktop, in import mode, filter argument is not case sensitive.

    However, in DirectQuery mode, filter argument is case sensitive, which inherits the "case sensitive" mode from Oracle, I execute a simple query in Oracle SQL Developer and find that the query will not return any values when I specify "COMPLETE" value.

    Regards,
    Lydia

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Joerobert,

In my first reply, I am using SQL Server data source.

I test the connection to Oracle in April update of Power BI Desktop, in import mode, filter argument is not case sensitive.

However, in DirectQuery mode, filter argument is case sensitive, which inherits the "case sensitive" mode from Oracle, I execute a simple query in Oracle SQL Developer and find that the query will not return any values when I specify "COMPLETE" value.

Regards,
Lydia

Joerobert's avatar
Joerobert
Advocate V
8 years ago

This is good information, thank you for working this problem for me.