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

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

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

Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

Fabric Career Hub

Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

Fabric Partner Community

Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.

Fabric Hack Slide Banner

Hack Together: The Microsoft Fabric AI Global Hack

Learn from experts, get hands-on experience, and win awesome prizes.