Forum Discussion
Change encoding of a specific column
- 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?
Thanks for the fast replies Greg_Deckler and amitchandak .
The data is not a csv, there's many steps before I get into the encoding step, it's a combination of many files and filetypes.
I always assumed that the more steps there are, the slower the refresh time becomes. Hence I'm cleaning up my queries to try and reduce the amount of steps and combining things as much as possible. But if you're saying it doesn't affect load times then I might just leave it like this.
In general I have a lot of queries where I first have to create a custom column based on an original column. I then remove the original column and rename the custom column to the same name as the original. If there's an easy way to fix this (perhaps there's a piece of code that should be changed in any step to make the change in the same column instead of in a custom column) I'd love to hear about it!
Thanks
Bas
Community ChampionMore 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