Forum Discussion
Case sensitive trouble Power Query -> DAX
Hello!
How solwe this trouble by transfering data from PQ to DAX?
For example the TABLE_NAME's "V_INS_BL_ATOM_ITEMS_TRD_FMD" and "v_ins_bl_atom_items_trd_fmd" is two different tables. But after loading trough Oracle or ODBC connections (no matter) from PQ this values was automatically converted to UPPER- (for ex. V_INS_DP_ATOM_ITEMS_TRD_LDWH) or to lower case (for ex. v_ins_bl_atom_items_trd_fmd). Possible randomly.
HERE is my example file, and here is the result. It's the same example file as for my previous question https://community.powerbi.com/t5/Desktop/COUNTROWS-is-BLANK/m-p/405998/highlight/true#M186396.
Such behavior is not expected.
Hi McCow,
I have consulted this issue internally before, this is by design now. As Power Query is case sensitive while data model isn't. See: https://social.technet.microsoft.com/Forums/en-US/f12496b0-7424-44e7-a384-a08694595899/power-query-load-not-maintaining-case-sensitive-data?forum=powerquery
Best Regards,
Qiuyun Yu
2 Replies
Hi McCow,
I have consulted this issue internally before, this is by design now. As Power Query is case sensitive while data model isn't. See: https://social.technet.microsoft.com/Forums/en-US/f12496b0-7424-44e7-a384-a08694595899/power-query-load-not-maintaining-case-sensitive-data?forum=powerquery
Best Regards,
Qiuyun YuHi Qiuyun,
If it's by desgin? Is there a workaroud to have case sensitive data?
Thanks,
Anna