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