Forum Discussion

Helper I

2 years ago

Column format not pulling through correctly from Excel source

Hi. I've got a data column in an Excel file that is formatted to 000, as it is a detail that needs to be viewed as a three digit code. But when I pull the detail into Power BI, any leading zeros...

Tips and Tricks

Anonymous

Not applicable

2 years ago

When you import Excel data into Power BI, Power BI will automatically identify the data type of each column and set the corresponding type based on your data in each column. You can undo this step in Power Query, and then you can set the data type of each column according to your actual situation.

I have created the following sample data in Excel:

The results of importing to Power BI are as follows:

The steps to restore leading zeros are as follows:

With the above steps you can restore the leading 0's in your columns.

How to Get Your Question Answered Quickly

If it does not help, please provide more details with your desired output and pbix file without privacy information (or some sample data) .

Best Regards

Jianpeng Li

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.