Skip to main content
Showing results for 
Search instead for 
Did you mean: 

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Helper II
Helper II

Dataflow vs T-SQL - Struggling with Views



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:

FROM dbo.Table_1;
Any ideas?




Community Support
Community Support

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 .





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


Helper II
Helper II

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.

Helpful resources

Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

March 2024  FBC Gallery Image

Fabric Monthly Update - March 2024

Check out the March 2024 Fabric update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.

Top Kudoed Authors