Encoding SQL Server

[mdelasheras]

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]

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]

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

[v-xjiin-msft]

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-45786e9c...

Thanks,
Xi Jin.

[mdelasheras]

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

[v-xjiin-msft]

Hi @mdelasheras,

Yes. For this part, SQL querys will be a better choice than handling it in Power BI.

Thanks,
Xi Jin.

[mdelasheras]

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!