PowerBi with postgres direct query

[sgopimca7]

Hi, We have some simple report with postgres direct query mode. 

The report working well but when we search the report using advanced search using contains then search is working only if the string matches case sensitive. Please help us on this

[V-lianl-msft]

Hi @sgopimca7 ,

In my test, there was no problem. Did you apply the filter after entering the string?

Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[sgopimca7]

Hi @V-lianl-msft , Are you using PostGreSQL Database with Direct Query option on Power BI?

[Greg_Deckler]

@sgopimca7 Sorry, can you explain "advanced search"? Where are you performing this advanced search?

[sgopimca7]

Hi @Greg_Deckler , Thanks for your suggestion. we will try it out.

[sgopimca7]

Hi @Greg_Deckler, Thank you so much for your support,

Please find the screenshot of the advanced filter. In city column we have some data with values as "Fake City". when we search the city column using Advanced search like "fake" then no rows are showing though some values with "Fake City" are available.

Please advice.

[Greg_Deckler]

@sgopimca7 Ah, got it now. Hmm, well potentially you could use SEARCH function to create a complex selector. SEARCH is case insensitive. SEARCH function (DAX) - DAX | Microsoft Docs