Forum Discussion

Helper I

8 years ago

Encoding SQL Server

Hi! I have some specials characters being displayed incorrectly when reading from SQL server. This may happen because of the Encoding so I would like to change it. Can i add a parameter in my conn...

Solution Sage

8 years ago

Hi mdelasheras,

As I know, you can't.

There's no Encoding option in Sql.Database() function in Power Query. Please refer: https://msdn.microsoft.com/en-us/query-bi/m/sql-database?f=255&MSPPError=-2147217396

Thanks,
Xi Jin.

mdelasheras
Helper I
8 years ago
What should I do to correct the character encoding? There is no way to display the right codification?
It's a bit annoying to show some tables with strange symbols
- mdelasheras
  Helper I
  8 years ago
  Hi!
  
  I have some specials characters being displayed incorrectly when reading from SQL server. This may happen because of the Encoding so I would like to change it. Can i add a parameter in my connection query?
  
  I tried like this but just getting some errors:
  
  let Origen = Sql.Database("serverIP", "database",Encoding="1252"),
  Origen{[Schema="schema",Item="item", Charset="1252"]}[Data],
  Thanks in advance!
- v-xjiin-msft
  Solution Sage
  8 years ago
  Hi mdelasheras,
  
  You can do the Replace in Power Query.
  https://support.office.com/en-us/article/replace-values-power-query-28256517-f1e9-4dc3-832f-45786e9cf721
  
  Thanks,
  Xi Jin.
  - mdelasheras
    Helper I
    8 years ago
    I don't really want to replace all values from all the tables I'm going to use...
    There may be a better option to solve it, maybe I can fix it by getting my tables with SQL querys and forcing the collation ?
    
    Thanks