Forum Discussion

New_worker's avatar
New_worker
Icon for Helper II rankHelper II
2 years ago
Solved

case 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 ...
Need Help
  • Kedar_Pande's avatar
    Kedar_Pande
    2 years ago

    New_worker 

    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.

Kedar_Pande's avatar
Kedar_Pande
Icon for Super User rankSuper User
2 years ago

New_worker 

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.

  • New_worker's avatar
    New_worker
    Icon for Helper II rankHelper II
    2 years ago

    Thank 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. 

    • Anonymous's avatar
      Anonymous
      Not applicable
      2 years ago

      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.