Forum Discussion
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 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!
6 Replies
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.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
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!
