Forum Discussion

sdghreza's avatar
sdghreza
Regular Visitor
5 years ago
Solved

Power BI does not show my steps

Hey everyone!

I have changed the type of almost 10 of my columns but power BI is merging them all in 1 step. do you know how can I expand it?

 

 

Need Help
  • v-deddai1-msft's avatar
    v-deddai1-msft
    5 years ago

    Hi sdghreza ,

     

    You can try to insert change type steps instead of add steps in order(every time you change the type of a column selecting the last step above change type. In my sample, it is source step):

     

     

    And if you have any base knowledge about m-query , you can edit the type in advanced editor by Table.TransformColumnTypes function:

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

    Best Regards,

    Dedmon Dai

     

     

2 Replies

  • aj1973's avatar
    aj1973
    Icon for Community Champion rankCommunity Champion
    5 years ago

    Hi sdghreza 

    For each data type change yo make rename the step and  then add a new step instead of Replace Current

     

  • v-deddai1-msft's avatar
    v-deddai1-msft
    Icon for Community Support rankCommunity Support
    5 years ago

    Hi sdghreza ,

     

    You can try to insert change type steps instead of add steps in order(every time you change the type of a column selecting the last step above change type. In my sample, it is source step):

     

     

    And if you have any base knowledge about m-query , you can edit the type in advanced editor by Table.TransformColumnTypes function:

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

    Best Regards,

    Dedmon Dai