Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
9 years ago

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.

 

 

Thanks a lot.

Need Help
Tips and Tricks

4 Replies

  • CahabaData's avatar
    CahabaData
    Memorable Member
    9 years ago

    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....

    • Anonymous's avatar
      Anonymous
      Not applicable
      9 years ago

      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-67c00b05040f

       

      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

      • v-ljerr-msft's avatar
        v-ljerr-msft
        Microsoft Employee
        9 years ago

        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.:smileyhappy:

         

        Regards