Forum Discussion
Helper IIValue 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 order with remark "tRAKAI" and it's the oldest of them. And all other orders for some reasons have this now as well.
It's like if it caches or something and while value is the same PBI reuses first one value. Can it be the case?
There's more orders with that word and all of them are stored as "tRAKAI", when in SQL they are "Trakai" 😞
Take a look at this post:
https://community.powerbi.com/t5/Issues/Data-Modeling-Uppercase-and-Lowercase-issues/idi-p/280362
v-haibl-msft
I can't really speak as to why this is the way it is, but from what I can tell it's the same bug/feature causing your issue.
/ J
10 Replies
- vanessafvg
Community Champion
are you able to share your file? i personally think its highly unlikely that power bi is doing this automatically, is it possible to see what your file is doing?
Tahreem24Super User
- amitchandak
RandomText , this is strange. Have you added any transformation on this column?
RandomTextToo 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".
- vanessafvggood idea, replicate it and see what happens. what you can also do is share your code from the advanced editor in power query
- RandomText
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"
- RandomText
Didn't found how to share. So uploaded to one drive.
New report has the same problem. Just added ODBC connection, added table that I need and removed all columns except order number, remark and date.
Try to download and tell me if there's no access or something.
