Case sensitive trouble Power Query -> DAX

[McCow]

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.

[v-qiuyu-msft · Accepted solution]

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

Best Regards,
Qiuyun Yu 

[AQ_2022]

Hi Qiuyun,

If it's by desgin? Is there a workaroud to have case sensitive data?

Thanks,

Anna