Power BI does not accept number format start with A

[peter8848]

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?

[TABLE="width: 145"]
<colgroup><col></colgroup><tbody>[TR]
[TD](Good one) 93100253431[/TD]
[/TR]
[TR]
[TD="align: right"][TABLE="width: 145"]
<colgroup><col></colgroup><tbody>[TR]
[TD]

(Bad one) [/TD]
[/TR]
[TR]
[TD]A 000071641064676[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
</tbody>[/TABLE]

Cheers,

Peter

 

[sandy666]

- maybe change format to text
- or remove all text characters then change to number
- column(s) shouldn't have mixed format

 

[peter8848]

Hi Sandy666,

thanks for your reply.

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

Cheers,

Peter

 

[sandy666]

I prefer leave source data "as is"...

but it's up to you