Forum Discussion
Solved
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 ...
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
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
Hi Qiuyun,
If it's by desgin? Is there a workaroud to have case sensitive data?
Thanks,
Anna