Power Query Drops Leading Zero

Jimmy801  and Anonymous ,

Thank you both for your suggestions.

There are few things i noticed since yestdreday.

1. Both files (RAW Data) are identical and formatted like each other.

2. For some reason in the Fact table data set power query adds the leading zero.

3. For some reason in the Dimension table data set power query drops out the leading zero.

4. When i upload both data sets in the query editor my default type for all columns is "Text". Have you noticed that on your end? When i uploaded an excel file, the default type for all columns is "123 ABC". That's something i've never noticed so far.

5. When i copied the RAW data from the csv files, pasted, and saved it in .xlsx the power query editor drops the leading zeros in both files. Which is a workaround... but originally i need them.

6. When i copied the RAW data from the csv files, pasted, and saved it in .xlsx and formatted it like official excel table, and uploaded them the power query editor drops the leading zeros in both files. Which is a workaround... but originally i need them. 

7. When i formatted the columns in the RAW data for both data sets in CSV and Excel, the result was the same as points 6 and 7.

Any ideas will be deeply appreciated,

Atanas