Forum Discussion

Anonymous

Not applicable

6 years ago

Solved

PowerBi - unable to convert

Can somebody from PowerBi team expain me this? Why tool tries to convert, where conversion is not needed at all??

Anonymous
6 years ago
Hello parry2k.
If you are referring to Advanced Editor window as "M" code, where let / in commands are, I have updated that code with the conversion
as it was Int64.type before.

I didn't know that updating column data type from the UI has no effect, will make a note for future.

Thanks!

4 Replies

parry2k
Super User
6 years ago
Anonymous seems like there is a step where this column is getting converted to number and then later you are changing it to text. Can you share "M" code, it will help to identify the issue.
- Anonymous
  Not applicable
  6 years ago
  Hello parry2k.
  If you are referring to Advanced Editor window as "M" code, where let / in commands are, I have updated that code with the conversion
  as it was Int64.type before.
  
  I didn't know that updating column data type from the UI has no effect, will make a note for future.
  
  Thanks!
  - parry2k
    Super User
    6 years ago
    Anonymous changing from the UI has impact but depends if you are adding a new step or you are changing on existing step, if you are changing type thru UI on existing step, it will update the M code if you are at other step, it will add another step but keep previous data type there. You need to understand how power query step works and then it is easy. Hope it make sense.