Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Power Query Drops Leading Zero

Dear community,   Hope my message finds you well!   I have 2 data sets which contain 1 fact table and 1 dimension table.   Both data sets are CSV files and all columns are formatted with type "...
Need Help
Show and Tell
Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hey Atanas, 

The two CSV files you have shared have already dropped the leading 0's for me. 

I think the column defaulted back to "general", rather than "text" when you sent over the file. 


It's odd when I change the column type to "Text" on the CSV. Update 20874 to 020874 (on the CVS), It comes into Power BI correctly on both tables. 

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Anonymous- thank you!

Can you please show me screenshot from the query editor?

I am thinking something might be different in my settings... when I upload the file i use this:

It is by default. But i tried that one as well:

 

None of them seem to work properly... both in excel and power bi. Can you please show me your settings?

 

Really appreciate your help,

 

Atanas

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Sure, notice I changed the type to Text 

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      Dang... what are your settings?

       

      Also which file is that? The problem to me happens in the dimension table.

       

      Thank you,

       

      Atanas

       

      Atanas