Forum Discussion

RandomText's avatar
RandomText
Icon for Helper II rankHelper II
6 years ago
Solved

Value in PBI has wrong capitalization

Hi,   we have noticed today that capitalization is different in PBI than in SQL.   In SQL it's stored as "Trakai" and when it's imported into PBI it says "tRAKAI". Why and how? There's...
Need Help
vanessafvg's avatar
vanessafvg
Icon for Community Champion rankCommunity Champion
6 years ago
good idea, replicate it and see what happens. what you can also do is share your code from the advanced editor in power query
RandomText's avatar
RandomText
Icon for Helper II rankHelper II
6 years ago

Sure.

 

let
    Source = Odbc.DataSource("dsn=iScala22", [HierarchicalNavigation=true]),
    iScalaDBS_Database = Source{[Name="iScalaDBS",Kind="Database"]}[Data],
    dbo_Schema = iScalaDBS_Database{[Name="dbo",Kind="Schema"]}[Data],
    OR01_Table = dbo_Schema{[Name="OR010200",Kind="Table"]}[Data],
    #"Removed Other Columns" = Table.SelectColumns(OR01_Table,{"OR01001", "OR01002", "OR01003", "OR01005", "OR01015", "OR01019", "OR01091"}),
    #"Filtered Rows" = Table.SelectRows(#"Removed Other Columns", each ([OR01002] = 0 or [OR01002] = 4 or [OR01002] = 1 or [OR01002] = 2))
in
    #"Filtered Rows"
  • tex628's avatar
    tex628
    Icon for Community Champion rankCommunity Champion
    6 years ago

    Is the capitalization inverted when you look at the record in Power Query as well? 

    • RandomText's avatar
      RandomText
      Icon for Helper II rankHelper II
      6 years ago

      tex628yeah, it's already like that after adding ODBC connection and that table. Without doing anything else.

       

      Edit:

       

      Here's screenshot of all orders with that remark. It's the oldest one and that's why I had an idea maybe to save data import it reuses because it's kinda the same word only different capitalization.

       

       

      Edit 2: There's 5th one in pbix file with order number: 0006579805

      in SQL it goes with remark "TRAKAI".