Forum Discussion
DirectQuery can't fold expression in Databricks
Hello, I am using the Databricks connector to PowerBI in DirectQuery mode and I have a rather simple expression to get some text in the middle of a string. Measure: Q = var ids=FIND(raw_msg[...
Thanks for the explanation. So I assume that the solution is to change it in the source.
Thats where I would start: Roche's Maxim of Data Transformation:
"Data should be transformed as far upstream as possible, and as far downstream as necessary"
If for some reason you cant, I would investigate doing it in MCode instead and as a last resort investigate Apache Spark syntax and see if there is an alternative.