Skip to main content
cancel
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.

Reply
st_0999
Helper II
Helper II

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. 

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?

 

st_0999_0-1694206945556.png

 

4 REPLIES 4
HimanshuS-msft
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 

HimanshuSmsft_1-1694471920320.png

and I diod got the below error .

 

HimanshuSmsft_0-1694471840336.png

 

Thanks
HImanshu

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

 

st_0999
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

Announcements
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.