Power BI does not accept number format start with A

peter8848

Board Regular
Joined
Oct 7, 2018
Messages
89
Hi All,

When loading data there is a column under number format but some starts from A and a space therefore power BI treats it as error, what would be the best way to fix it? I am thinking about fix the source excel data change it to text and add a apostrophe otherwise it shows scientific format?

(Good one) 93100253431


(Bad one)
A 000071641064676

<colgroup><col></colgroup><tbody>
</tbody>

<colgroup><col></colgroup><tbody>
</tbody>

Cheers,

Peter
 

Some videos you may like

Excel Facts

Round to nearest half hour?
Use =MROUND(A2,"0:30") to round to nearest half hour. Use =CEILING(A2,"0:30") to round to next half hour.

sandy666

Well-known Member
Joined
Oct 24, 2015
Messages
5,075
- maybe change format to text
- or remove all text characters then change to number
- column(s) shouldn't have mixed format
 

peter8848

Board Regular
Joined
Oct 7, 2018
Messages
89
Hi Sandy666,

thanks for your reply.

So it is better to fix it in the source data or in Power BI?

Cheers,

Peter
 

Watch MrExcel Video

Forum statistics

Threads
1,096,065
Messages
5,448,187
Members
405,490
Latest member
Larry of Oz

This Week's Hot Topics

Top