Forum Discussion
Helper IIcase sensitive data in Direct Query mode
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.
Helper IIThank you Kedar_Pande for the reply. Confirmed this Solution: You add an index key and normalize casing in the data source will work for direct query mode.
Hi New_worker , hello Kedar_Pande and samratpbi, thank you for your prompt reply!
Thank you for discussing the issue and confirming the solution.
Please remember to accept your solution as answer.
This will greatly assist others who encounter similar questions in the forum.
Thanks again for your valuable contribution.