PowerBI Changing long numbers in a text column

[Jorrit6]

I have an excel file which I use as data source in PowerBI. When I examine it n Excel I see the following:

9896700000111100432411004310

9896700000111100432411004311

9896700000111100432411004312

9896700000111100432411004313

When I import this in PowerBi, I shows up as:

9896700000111100432411004310

9896700000111100432411004310

9896700000111100432411004310

9896700000111100432411004310

All data is at all times fomated as TEXT. I do not want to use these as numbers. Why is PowerBi rounding this down? And how can I fix this?

[v-juanli-msft]

Hi

It seems when imported, the data duplicated and changed to text type automatically, right?

Though I can't reproduce your problem, could you share me an excel file or a pbix file including some data as shown?

Best Regards

Maggie