Forum Discussion
Helper IIid duplicate due to case sensitive
Hi zanottiluca,
Power BI Desktop's query editor and M language is case-sensitive while Power BI Desktop's data model and DAX language is not case-sensitive. Someone has submitted this problem here, you could click to vote it up.
Workaround is to create a surrogate key like described here:
Create a Dimension Table with Power Query: Avoid the case sensitivity bug!
Regards,
Yuliana Gu
Microsoft EmployeeHi zanottiluca,
Power BI Desktop's query editor and M language is case-sensitive while Power BI Desktop's data model and DAX language is not case-sensitive. Someone has submitted this problem here, you could click to vote it up.
Workaround is to create a surrogate key like described here:
Create a Dimension Table with Power Query: Avoid the case sensitivity bug!
Regards,
Yuliana Gu
Helper IIThanks Yuliana for the reply and for the link/clarification , much appreciated.
I have voted the idea indeed.
Thanks again
Luca