Forum Discussion
Change encoding of a specific column
Hi, I have a column with lots of characters like Ä Â Ñ etcetera. Instead of doing a search and replace for each of these characters, I found this piece of code which changes the encoding from Window...
- The only advice I would give is to rename the original column BEFORE you add the column. Then you can save the step of renaming the new column because you can use the correct name when you create the custom column.
More steps doesn't necessarily mean slower refresh, depends what you're doing in each step.
If you have lots of steps where you change the data type for example, and change from number to currency then back to number, that should be cleaned up.
Hope that makes sense?
Good advice, thanks AllisonKennedy !
Hi Anonymous
Could you tell me if your problem has been solved? If it is, kindly Accept it as the solution. More people will benefit from it. Or you are still confused about it, please provide me with more details about your data model and your problem or share me with your pbix file from your Onedrive for Business.
Best Regards,
Rico Zhou