Forum Discussion
Case Sensitivity
Power Query is case-sensitive, that's why you can add an index there to protect your sensistivity since Power BI is case-insensitive.
Hello! The main engine of Power BI is case-insensitive. However, you can create a workaround for this by creating an index for the different case values in Power Query because case-sensitivity is recognized there. Here is a blog that should help explain in more detail: Letter case-sensitivity in DAX, Power BI and Analysis Services - SQLBI
I thought at one time, case sensitivity was not auto-corrected in PowerBi . Did this change or perhaps I am thinking of relationships between tables or some other element.
Power Query is case-sensitive, that's why you can add an index there to protect your sensistivity since Power BI is case-insensitive.