Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
Aspi
Helper I
Helper I

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

csv data.jpgPower Query Editor.jpgDashboard.jpgHello 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.

4 REPLIES 4
v-jingzhang
Community Support
Community Support

@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
Helper I
Helper I

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.

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.

011901.jpg

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
Community Champion
Community Champion

Hi @Aspi 

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

 

Regards
Amine Jerbi

If I answered your question, please mark this thread as accepted
and you can follow me on
My Website, LinkedIn and Facebook

Helpful resources

Announcements
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.