Loading data into powerbi

Hi ktt777 ,

I have checked your data source. The original data doesn't contain "00".

There are two ways that can implement it. You could follow my step to have a try.

• In Model view > choose Whole number and Custom format : 00#####

https://docs.microsoft.com/en-us/power-bi/create-reports/desktop-custom-format-strings

• Create a formula using FORMAT()

Column = FORMAT(test[Project (7 digits)],"00#####")

https://docs.microsoft.com/en-us/dax/format-function-dax

Hi,

You can add a Custom column as 

Leading zeros = Text.PadStart(Number.ToText([Column2]),7,"0")

It should resolve your problem.

Thanks