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?

(Good one) 93100253431

(Bad one) A 000071641064676 <colgroup><col></colgroup><tbody> </tbody>

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

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