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?