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

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