Forum Discussion
Display / Import Mixed Character Set
You'd have to do it in the Advanced Editor and the documentation on those functions is really lacking. Perhaps ImkeF or MarcelBeug might have some insight into the proper use of those functions. Here is another article that I found that might help. It doesn't use those functions but changes the encoding type on import:
Check out the Text.Encoding functions in Power Query:
https://msdn.microsoft.com/en-us/library/mt826838.aspx
Hi smoupre,
Thanks for the reply. I'm pretty new to PowerBI - how would I apply these functions to a column, and which one would I use - the help pages don't have a lot of info!
Thanks,
Sam
You'd have to do it in the Advanced Editor and the documentation on those functions is really lacking. Perhaps ImkeF or MarcelBeug might have some insight into the proper use of those functions. Here is another article that I found that might help. It doesn't use those functions but changes the encoding type on import:
Ah, OK - thanks for links and assists Greg_Deckler - much appreciated!
Hello Greg_Deckler, Anonymous
I am also facing the similar problem.
The imported data from database is showing me some special characters as explained in the first post.
I am not able to understand how I can set character set to utf8 for this column of table in Advance query option.
Kindly help.
