Forum Discussion

st_0999's avatar
st_0999
Helper II
2 years ago

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?

 

 

Dataflows

4 Replies

  • st_0999's avatar
    st_0999
    Helper II
    2 years ago

    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's avatar
      st_0999
      Helper II
      2 years ago

      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.

  • HimanshuS-msft's avatar
    HimanshuS-msft
    Microsoft Employee
    2 years ago

    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's avatar
      st_0999
      Helper II
      2 years ago

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