Forum Discussion

Birdjo's avatar
Birdjo
Resolver II
8 years ago
Solved

Set column type while expanding from merged query

Hello, Here's a quick question: I am expanding a column after merging. In the source the column type is text and has values like: 0333, 0555, 0888 While expanding it expands like a whole number an...
Need Help
  • Birdjo's avatar
    Birdjo
    8 years ago

    cwebb 

    I am working with Excel using Excel.Workbook(Web.Contents())

    In matter of fact the type doesn't matter untill I don't lose the zeros. Like 0003 > 3, 0005 > 5.

     

    MarcelBeug the change of the data type occurs while expanding and zeros are lost. I guess there's nothing to get them back.
    It is very nice how you values remain their zeros while their type is a number.

    My temporary solution was to change the type to a number everywhere and duplicate the column with type text in the table that I visualize. Works pretty good but it would be better if that was not necessary. 


    Thank you both!

Birdjo's avatar
Birdjo
Resolver II
8 years ago

I use the latest version of Power BI. There was a second update this month.
No new step is added.

Maybe you think that shouldn't happen or event it's not possible but that's what happened.

cwebb's avatar
cwebb
Advocate V
8 years ago

Can you post a screenshot of the Query Editor showing the output of the query that gets data from Excel, before you do the merge, please? If possible could you also post the M code for all of your queries too?

 

Thanks,

 

Chris

  • Birdjo's avatar
    Birdjo
    Resolver II
    8 years ago

    cwebb

    I can't post the M Code, but trust me there is nothing that usually would cause such a thing.

     

    Here is an image of the source and destination (the expanded column):

  • v-jiascu-msft's avatar
    v-jiascu-msft
    Microsoft Employee
    8 years ago

    Hi Birdjo,

     

    The data type of the destination is number. Can you change it to Text manually?

     

     

     

     

     

     

     

     

     

     

     

     

     

     

    Best Regards,

    Dale

     

     

  • v-jiascu-msft's avatar
    v-jiascu-msft
    Microsoft Employee
    8 years ago

    Hi Birdjo,

     

    Could you please mark the proper answer as solution or share the solution if it's convenient for you? That will be a big help to the others.

     

    Best Regards!
    Dale

  • Birdjo's avatar
    Birdjo
    Resolver II
    8 years ago

    That way the zeros are missing.