Forum Discussion
New_worker
Helper II
Helper IIcase sensitive data in Direct Query mode
You have a data source that contains a column. The column contains case sensitive data. You have a Power BI semantic model in DirectQuery mode. You connect to the model and discover that it contains ...
Yes, normalizing the casing in Power Query or at the data source level is the recommended approach to resolve the case-sensitivity issue in DirectQuery mode. Adding an index key can help distinguish rows if needed, but normalizing should be your first step to avoid undefined results.
samratpbi
Super User
Super UserHi,
The best option is to make the case consistent in the backend itself. If not possible, then Power Query. Last thing you can do is in DAX, you may use LOWER or UPPER functions to make all values appear in the same case.
Hope this resolves your problem, if it does, then please mark it as solution provided, Thanks!
New_workerHelper II
Helper IIHi samratpbi ,
Thanks for your reply. So based on the solution "add an index key and normalize casing in the data source" should not work?