Power BI Query/Dashboard displays +11 (overflow) instead of the full string of numbers.

[Aspi]

Hello all, I have csv file that contains several columns one of which is a column with 12 digit numbers. When I export/upload the data into Power BI this column comes through as ######E+11 in the Power Query Editor as well as the dashboard. I have tried all possible options of changing the type to whole numbers etc etc but nothing seems to work. Can someone please advise as to how do I get the whole 12 digits displayed in my final dashboard so that I can run a filter on this column. Thank you and regards.

[v-jingzhang]

@Aspi Has the problem been solved? If so, accept the appropriate post as the solution or post your own solution to help other members find it quickly. Thanks.

[Aspi]

Hi AJ,

Thanks for your response, I did format the column in the csv file to Numbers as it was coming through as Text from the prime source data. Then uploaded it into Power BI yet no difference. Please help.

The first image that you see in my query shows the formatted data (highlighted column). 

Regards.

[v-jingzhang]

Hi @Aspi ,

Has this problem been solved? I cannot reproduce this.

I format the column in csv file to Number and import it into Power BI Desktop. After that, it shows the scientific format in Power Query Editor. But when I apply it and go to Power BI Desktop, it displays 12 digit numbers well. Below is my settings.

Additionally, if the ticket numbers will not be used for any mathematical calculation in the model, I think you could also transform this column into Text data type as a workaround.

Regards,
Community Support Team _ Jing Zhang
If this post helps, please consider Accept it as the solution to help other members find it.

[aj1973]

Hi @Aspi 

Have you tried to format the column in the CSV file before importing it?