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

vanessafvg 

Too much sensitive information to feel comfortable to share. But will try to create new report with only that table and only with relevant columns, maybe problem will be there as well.

 

Tahreem24it refreshes every night through gateway, but will take PBIX file and refresh through Desktop software.

 

amitchandakNo. And I don't even know what transformations could do that. There's more remarks like "aco" and "ACO". All of them became "aco".

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