Forum Discussion

wardy912's avatar
wardy912
Super User
1 year ago
Solved

Case sensitive slicer when using direct query

Hi everyone,    We have a Power BI report connected to Fabric using Direct Query, the slicers are case sensitive. There doesn't seem to be any option to change this. Does anyone have any ideas? ...
Need Help
  • danextian's avatar
    danextian
    1 year ago

    Create a column in the source that removes can sensitivity - either lower or uppercase the entire text string.

wardy912's avatar
wardy912
Super User
1 year ago

Thanks Vivien,

 

 It's direct query connecting to a lakehouse (which as I write this, makes me think we should use direct lake).

Would changing to direct lake fix the issue?

 

I'll look into a fix for the column in the notebooks

vivien57's avatar
vivien57
Super User
1 year ago

Hi wardy912 

This would allow you to create a calculated column in the model (powerBI) to manage case sensitivity (without managing it at the data source level).

Please feel free to give a kudo and validate the solution if it suits you.

Have a nice day,

Vivien