topic PowerBi with postgres direct query in Developer

PowerBi with postgres direct query

sgopimca7 — Sun, 15 Aug 2021 11:56:53 GMT

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

Re: PowerBi with postgres direct query

Greg_Deckler — Sun, 15 Aug 2021 22:09:52 GMT

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

Re: PowerBi with postgres direct query

sgopimca7 — Mon, 16 Aug 2021 05:22:52 GMT

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.

Re: PowerBi with postgres direct query

Greg_Deckler — Mon, 16 Aug 2021 12:45:39 GMT

@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

Re: PowerBi with postgres direct query

V-lianl-msft — Wed, 18 Aug 2021 05:32:18 GMT

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.

Re: PowerBi with postgres direct query

sgopimca7 — Wed, 18 Aug 2021 06:45:17 GMT

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

Re: PowerBi with postgres direct query

sgopimca7 — Wed, 18 Aug 2021 06:46:51 GMT

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