Forum Discussion

gusdahu's avatar
gusdahu
Icon for Helper IV rankHelper IV
7 years ago
Solved

How do I add Leading Zeros?

Power BI Community,   I have a data set that includes vendor IDs. Each vendor ID is ten digits long and usually begins with six or seven zeros followed by another digit. See examples below:   Ven...
Need Help
  • Henri-M's avatar
    Henri-M
    7 years ago

    Hi,

    I propose two approaches:
    Approach 1: When your data is loaded in power query look on the right side your query settings and DELETE CHANGED TYPE

     

     

    Approach 2: Go to Your Power Query

    File =>Cuurent File =>Data Load => Type Detection: UNCHECK "Automatically detect colum types and headers for..." and reload your data.

     

    Tell me if it's OK.

    Thanks

Henri-M's avatar
Henri-M
Regular Visitor
7 years ago

Hi,

I propose two approaches:
Approach 1: When your data is loaded in power query look on the right side your query settings and DELETE CHANGED TYPE

 

 

Approach 2: Go to Your Power Query

File =>Cuurent File =>Data Load => Type Detection: UNCHECK "Automatically detect colum types and headers for..." and reload your data.

 

Tell me if it's OK.

Thanks