Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Why is CONTAINSSTRING not Available when you Direct Connect to a Tabular Data Model but is available With a Local Data Model? is this a bug. I can Add Measures to My Direct Connect Model, so why can't I use this function?
Solved! Go to Solution.
Because DAX measures are executed by the engine that is hosting the data model. Containsstring is a brand new function that is only available in Power BI and SSAS 2019 CTP 2.3 or later (see https://dax.guide/containsstring/)
So if you are connecting to SSAS 2017 or earlier it will not have this function available.
Because DAX measures are executed by the engine that is hosting the data model. Containsstring is a brand new function that is only available in Power BI and SSAS 2019 CTP 2.3 or later (see https://dax.guide/containsstring/)
So if you are connecting to SSAS 2017 or earlier it will not have this function available.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
113 | |
97 | |
85 | |
70 | |
61 |
User | Count |
---|---|
151 | |
121 | |
104 | |
87 | |
67 |