Number formatting after excel import

[rpinxt]

Have on sharepoint this excel file:

As you see the config has a leading zero. And that is what I want.

I did this with custom formatting in excel not with adding a ' in front of it.

But when I import it in power bi :

Gone is the leading zero.

Is there a way to get the leading zero back in the original column?

Or will I have to make a measure or calculated column for that?

[rpinxt · Accepted solution]

Thanks both but I found the way to fix this in Power BI.

So formatted it as a whole number and in the model view you can go to formatting in the properties pane.

Chose your field.

Set format to custom and for me only had to format it like 00

All good now 😄

[playtunes]

 You can try to format the column and add a prefix ("0"). The type will be changed to text

[FreemanZ]

Try to format the config column as TEXT in Excel. After loaded to Power Query, check if the column is converted to number in the step named "Changed Type". You can delete the steps named "Changed Type" added automatically.

[rpinxt]

@FreemanZ when I format in excel as Text I again lose the leading zero already in excel.

Will I then get it back in power query?