Forum Discussion
Getting error: Internal Query Processor Error
Hello, the issue apparently is the use of a fuction on some views on F&O and since fabric does not support fuctions on the dw, that looked like it was causing the errors.
Here is what they wrote
The team was finally able to root cause the issue. The problem occurs to the fact that the query uses a scalar UDF (GetValidFromDateInContextInfoAsTable) which can’t run in distributed mode in Fabric DW – we call these non-inlineable scalar UDFs. For user queries, we have a process to rewrite queries like this one so that it runs optimally in Fabric DW. However, I understand that this query is produced on the fly by Dynamics AX. It seems that Dynamics is not optimized for Fabric DW quite yet. I’m wondering if you’d consider opening a ticket with them for visibility, chances are they have a workaround, or you may need to wait until Dynamics is supported in Fabric Data Warehouse.