There are 2 basic issues i am facing while exporting report:-
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"
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.
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....