special character showing issue while fetch from postgresql database to power bi

[nisha_deepak]

i am  creating a report in desktop using data taken from postgresql database.I use postgres odbc driver .

while fetching data using select query i try like this.

After loading data from db to power bi desktop some of the data is not correctly showing like in database.Some data is showing like special characters.But the problem is some of the same value having issues ...some of the same data is not having any issue.

MY database column is like this.

But same thing is showing differntly in powerbi

here 2 value in column is entirely different compare with data from database .These type of lot of data having issue.

Plse give some suggestions.

[PhilipTreacy]

Hi @nisha_deepak 

Do you have to explicitly set the encoding to UTF-8?  Can you leave this out?

Phil

[PhilipTreacy]

Hi @nisha_deepak 

Using Clean will remove non-printable characters so in this case that won't help as you can print â€ 

You can use Text.Select to leave you with only the characters you want.  Add a Custom Column in the query editor and use this line of code, wehre the characters you want to keep are in the List that forms the  function's 2nd parameter

Text.Select([item_name] , {"a".."z", "A".."Z", "0".."9", " ", "#", ";", "-"})

https://docs.microsoft.com/en-us/powerquery-m/text-select

Phil

---

If I answered your question please mark my post as the solution.
If my answer helped solve your problem, give it a kudos by clicking on the Thumbs Up.

[mahoneypat]

You can try the Clean option for that column on the tranform tab.  If that doesn't work, you can use Text.Select to keep only the text characters you want.

Regards,

Pat

[nisha_deepak]

I have a doubt that data  missing  issue is there,while fetching data from database to power bi.So, after getting data in power bi ,how can i get correct data by try the Clean option for that column on the tranform tab.Plse help me?