cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
mridul Member
Member

Exporting Data Issue with Character Length 16

Hi All, 

 

There are 2 basic  issues i am facing while exporting report:-

Issue 1:- 

I have two column as shown below :-

Data Type for both the column is TEXT .

Length for Contract Number is --> 11

Length for AssetID is --> 16

When i am Exporting Data from PBI Desktop , i get the Contract Number correctly exported and Data Type in csv shows "General"

BUT, for 

Asset ID , data type in Csv shows as Scientific , like this 2.5E+15 , and when i try to expand this Number it last value is ZERO for all the records . It should be 2502440000000067 , but it is 2502440000000060 -- (Last Digit got changed for all the records)

 

Issue 2 : When i am using another system with 2013 version , i see the data get exported in only one column with comma seperated . It should be different columns. Any suggestion why is this behaviour.

 

cmp.png

 

Thanks a lot.

4 REPLIES 4
CahabaData New Contributor
New Contributor

Re: Exporting Data Issue with Character Length 16

csv has no data type and so I presume you are opening it in excel to view

 

to isolate the problem, open that csv in notepad and verify if that string indeed has incorrectly the 0 - in which case it is definitely the Power BI export - rather than the excel opening logic...

 

not sure why PBI export would not abide by the field type....

www.CahabaData.com
Highlighted
mridul Member
Member

Re: Exporting Data Issue with Character Length 16

@CahabaData : I opened the downloaded file in notepad. It works well in notepad and then last digit is what it should be. 

                         There is limitation of Number precision = 15 digit as shown in this link 

https://support.office.com/en-us/article/Excel-specifications-and-limits-ca36e2dc-1f09-4620-b726-67c...

 

BUT , i need the same in Excel with 16 digits. Any work around.

Becasue we are using another system to upload downloaded csv report from Power BI for further financial calculations

 

Thanks

Microsoft v-ljerr-msft
Microsoft

Re: Exporting Data Issue with Character Length 16

@mridul


BUT , i need the same in Excel with 16 digits. Any work around.

Becasue we are using another system to upload downloaded csv report from Power BI for further financial calculations


As this is just a limitation in Excel, it may be not possible to do it in this scenario. As the issue is more related to Excel now, I would suggest you also go to Excel forum for better assistance.Smiley Happy

 

Regards

CahabaData New Contributor
New Contributor

Re: Exporting Data Issue with Character Length 16

yep not a PBI export issue; is excel default..... so I'll say it is not unreasonable for excel to think a 16 digit field should default to scientific notation.  I'm not a hard core excel guy but some here are.  All I know is to try and manually reformat that column and see what happens (maybe you've done that and still lose the 16th digit)....or another trick we use on the database side is to stuff some alpha info or commas or stuff like that in the first row of that field....as that will help force excel to see it as text rather than data - - though such a work-around maybe not feasible in this situation......  possibly you can format an excel sheet and then import that csv data file - - and it will keep your text format of that column...not really sure....

 

 

 

www.CahabaData.com

Helpful resources

Announcements
Exclusive LIVE Community Event #3 – Ask Arun Anything

Exclusive LIVE Community Event #3 – Ask Arun Anything

Join us in the third Triple A event!

Meet the 2020 Season 1 Power BI Super Users!

Meet the 2020 Season 1 Power BI Super Users!

It’s the start of a new Super User season! Learn all about the new Super Users and brand-new tiered recognition system.

Super User Challenge: Can You Solve These?

Super User Challenge: Can You Solve These?

We're celebrating the start of the New Super User season with our first ever Super User 'Can You Solve These?' challenge.

Power BI Desktop Update - February 2020

Power BI Desktop Update - February 2020

We are super excited for our update this month, as we are releasing two of our top community requests!

Power Platform Online Conference

Power Platform Online Conference

Join us for the first ever Power Platform Online Conference!

Top Solution Authors