Forum Discussion

nisha_deepak's avatar
nisha_deepak
Helper III
5 years ago
Solved

text column not correctly encoding

I am using some of text type column from postgresql database for creating report in power bi.After loading data to power bi some of the values in column having some misamatch while comapare that value with database value.

Example...if i have columnin database  named  address which is having  value like this in School District - Westridge.

But ,when i load these column to power bi by connecting to database  its value changed to School District – Westridge.

these just an example,lot of values having issues...some value is convereted to  like this..– .Some are convereted to some other special characters.Issue is while fetching data from db and after loading to power bi..So i can't do anything after getting data to power bi...Also, i can't do replace value function in power bi because we can't predict whicha are the values changed to which special characters.Am using Set client_encoding to 'UTF-8'; . In query part...plse help?

  • Hi, nisha_deepak 

    Could you please tell me whether your problem has been solved?

    Here is the same discussion on how to encode files to make Power BI display normally.

    You  can check if   Anonymous  's  solution in this  thread  works for you.

     

     

    Best Regards,
    Community Support Team _ Eason

2 Replies

  • v-easonf-msft's avatar
    v-easonf-msft
    Community Support

    Hi, nisha_deepak 

    Could you please tell me whether your problem has been solved?

    Here is the same discussion on how to encode files to make Power BI display normally.

    You  can check if   Anonymous  's  solution in this  thread  works for you.

     

     

    Best Regards,
    Community Support Team _ Eason