Forum Discussion
Solved
link for fabric case sensitive issue
good afternoon we have a powerplatform enviroment with dataverse which is configured to be linked/sourced with our d365FO; we created a fabric link to have access to d365FO data via dataverse fabric...
Hi mama_Hani,
In warehouses and lakehouses, everything is case sensitive by default. This was also a bit of a struggle for me and my team coming from a SQL Server environment where things are not case sensitive by default.
You can change the collation in the warehouse to be case insensitive: https://learn.microsoft.com/en-us/fabric/data-warehouse/collation
If you found this helpful, consider giving some Kudos. If I answered your question or solved your problem, mark this post as the solution.
