Forum Discussion
Dataflow vs T-SQL - Struggling with Views
Hi, I thought I'd try using SQL views on a LakeHouse table, via it's SQL EndPoint. The Grouping I'm doing is much, much faster than the Dataflow, and doesn't have the 10 minute time-out limit....
Ok, I removed the ";" at the end, and this simple view worked.
But it doesn't work for views that start with
CTE, using the WITH expression, or tables where I use the ORDER BY function.
Seems strange as ORDER BY is so commmon?
Ok, I got this to work by wrapping the view in a stored procedure (with ordering)
I got the view to work by creating it programatically. the GUI doesn't work, its a bug.