'Contains' and 'Does not contains' Filters on string data type in Power BI (Oracle DB)

[Anonymous]

Hi, 

The 'Contains' and 'Does not contains' filter in Power BI is not working for the Oracle database.

The data type of the column is Varchar and the Power Bi Version is March 2018.

Is there any workround available ??

 

[v-yuta-msft · Accepted solution]

Hi anandtiwari,

Currently, power BI DirectQuery only supports Oracle 12 or above. Oracle 11 is not supported.

Could you please check if the Oracle version is 12 or above?

Regards,

Jimmy Tao

[v-yuta-msft]

Hi anandtiwari,

I have reproduced your issue on my side. And I have reported this issue to PG, will update here when I receive any result.

Regards,

Jimmy Tao

[Anonymous]

Hi Jimmy,

Did you get any information from PG on the issue "

Contains' and 'Does not contains' Filters on string data type in Power BI (Oracle DB)

 " ? 

[v-yuta-msft · Accepted solution]

Hi anandtiwari,

Currently, power BI DirectQuery only supports Oracle 12 or above. Oracle 11 is not supported.

Could you please check if the Oracle version is 12 or above?

Regards,

Jimmy Tao

[Anonymous · Accepted solution]

Hi Jimmy, 

No its not !! it is  Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production. 

Anyways !! Thanks for your response on this.