Looker studio MSSQL Error

Looker Studio scope identity issue connecting to Microsoft SQL

Looker Studio cannot connect to your data set.

Sorry, we encountered an error and were unable to complete your request.

Failed to execute connection with error: 'SCOPE_IDENTITY' is not a recognized built-in function name.

Error ID: 01c78595

 

0 0 63