Forum Discussion
Really bizarre issue with SQL function not returning result in Desktop but does on service!!!!
I had a model that was working perfectly well and then our servers moved to Azure. this caused some issues with some custom SQL functions that calculated duration. These were fixed and if I run the...
Hi masplin ,
nothing super obvious comes to my mind here. Just that the SQL-code looks a bit rough in general.
I would start rebuilding the SQL-query with native Power Query steps, check the auto-generated M-Code (view native query) and replace your SQL-code with it subsequently.
Do this step by step until PBID hits the error. That should identify the delinquent query element(s).