Forum Discussion

st_0999's avatar
st_0999
Icon for Helper II rankHelper II
3 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....
Dataflows
HimanshuS-msft's avatar
HimanshuS-msft
Icon for Microsoft Employee rankMicrosoft Employee
3 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
    Icon for Helper II rankHelper II
    3 years ago

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