locked
Data import issue RRS feed

  • Question

  • Hi,

    I've a weird issue while importing data from sql server to power pivot. There's a table which contains 3 rows with one of the column contains following value. 

    lname

    Lname

    Lname

    But, while importing to power pivot..value changes to small case. The values are fine if i import in excel data import.

    lname

    lname

    lname

    Please let me know, whats the reason for this issue. Have anyone faced this type of issue.


    Try this sample code and import in powerpivot...'Lname' changes to 'lname'

    create table test(sd varchar(10))

    insert into test
    select 'Lname1'
    union all
    select 'lname'
    union all
    select 'Lname'

    Is this a Bug?

    • Edited by msbimsbi Friday, October 26, 2012 7:28 AM added more info
    Thursday, October 25, 2012 5:16 PM

Answers

  • The powerpivot does that for datacompression and remove redundency in column values. It is Case Insensitive.

    No workaround for this and it is by product design to make models more efficient .


    Microsoft Partner Services Organization

    Saturday, October 27, 2012 7:51 AM