Dataflow vs T-SQL - Struggling with Views

[st_0999]

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. 

The only problem is, when I try saving the SQL as a View, give it a name, I keep getting the following error, even on SQL statements as simple as:

SELECT *

FROM dbo.Table_1;

Any ideas?

[HimanshuS-msft]

Hello @st_0999 
Thanks for using the Fabric community.

Well it does  throws a valid error directing to remove ";" 
This is what I tried 

and I diod got the below error .

Thanks
HImanshu

[st_0999]

Yes, but I don't think the GUI works, for example, if the query starts with a CTE.

[st_0999]

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?

[st_0999]

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.