cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Anonymous
Not applicable

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
Memorable Member
Memorable Member

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
Anonymous
Not applicable

@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

@Anonymous


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

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
Power BI October Update 2021.jpg

Power BI Release

Click here to read more about the October 2021 Release!

Microsoft Ignite 768x460.png

Find your focus

Explore the latest tools,training sessions,technical expertise, networking and more.

Power BI Womens Summit 2021 768 x460.jpg

Interviews, learning sessions, allies, and more!

#PowerBIWomenSummit

Teds Dev Camp Oct. 2021 768x460.jpg

Power BI Dev Camp - October 28th, 2021

Mark your calendars and join us for our next Power BI Dev Camp!