cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Anonymous
Not applicable

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

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 ??

 

 

 Step 1.JPGStep 2.JPG

2 ACCEPTED SOLUTIONS

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

View solution in original post

Anonymous
Not applicable

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. 

View solution in original post

4 REPLIES 4
v-yuta-msft
Community Support
Community Support

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
Not applicable

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)

 " ? 

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

View solution in original post

Anonymous
Not applicable

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. 

View solution in original post

Helpful resources

Announcements
PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

April Update

Check it Out!

Click here to read more about the April 2021 Updates!

MBAS Carousel

Sign up for our May 4th event!

May the fourth be with you, join us online!

secondImage

The largest Power BI virtual conference

100+ sessions, 100+ speakers, Product managers, MVPs, and experts. All about Power BI. Attend online or watch the recordings.