Forum Discussion
text column values encoding issue
..I use postgres data source for report creation from odbc...In connection string postgres Unicode driver class is used...i used text column for report creation.While taking data from database,column...
That has nothing to do with Unicode. It has to do with the fact that Power Query is case sensitve but Power BI is not. Your source data likely has both spellings, ad Power BI is randompy picking one of them and then grouping all value variations under it.
You can "fix" it by applying an appropriate transform in Power Query.