When you create a DirectLake Semantic Model in the Power BI Service (Which is the only way for now), the default Collation is
To switch it to Case Insensitive, which would be the right choice for 99% of Semantic Models, one has to go through a certain number of steps using XMLA tools such as Tabular Editor, VS Code...etc
It would be really nice to make this easier, especially for non advanced users.
In addition, this would democratize a bit more the use of DirectLake which is a great compromise between Import and DirectQuery modes.
2 Comments
- Status added:New
- By transforming from the Import model to DirectLake, the case sensitivity is activated, which is confusing. We would need a native way of switching this.
