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[...
DAX is more limited when connected Direct Query in general. Additionally, DirectQuery on Databricks is more limited than Direct Query SQL Server. The reason being is that DirectQuery on Databricks leverages Apache SQL where Direct Query on SQL Server uses TSQL.
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.