Invalid Mashup Expression using supplied values. inner exception: Microsoft SQL: Line 1: Incorrec...

(0) Share

Report

Posted on by sir_ironpants

Whenever I attempt to setup a SQL Server connection in PowerApps, I receive the following error:

"Invalid Mashup Expression using supplied values. inner exception: Microsoft SQL: Line 1: Incorrect syntax near 'max'."

I've selected "Connect using on-premises data gateway" (which I've installed on my office machine).

For SQL server name, I'm using the IP address of the server.

I selected Windows Authentication Type.

The SQL Server information is as follows:

Product: Microsoft SQL Server Standard Edition
OS: Microsoft Windows NT 5.2 (3790)
Platform: NT INTEL X86
Version: 8.00.2066

Any thoughts on what is causing the error?

Thanks!

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (0)

v-monli-msft Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!

Hi @sir_ironpants,

Please check the following things.

1. Please make sure your database engine is configured to accept remote connections.
2. Please make sure that you create an exception on the firewall for the SQL Server instance and port you are using.
3. Please check if your SQL server services is up and running properly.
4. Please make sure that you enable TCP/IP in SQL Server Configuration

This article could be a reference for you:
https://www.mssqltips.com/sqlservertip/2340/resolving-could-not-open-a-connection-to-sql-server-erro...

Make sure that you have gone throught the below article:

https://powerapps.microsoft.com/en-us/tutorials/connection-azure-sqldatabase/

Best regards,
Mona

Was this reply helpful? Yes No
sir_ironpants 7 on at

Like (2)

Report
Copy link

Link copied!

Thank you for the reply!

Unfortunately, even after checking all the suggested things in your response, I still cannot connect to the on-premises SQL Server. I receive the same "Invalid Mashup Expression" error every time I try to establish a connection in PowerApps.

Is there anything else you can think of for me to try?

Was this reply helpful? Yes No
rajeevkumar 2 on at

Like (0)

Report
Copy link

Link copied!

I'm also getting the same error, checked all rules are set.

Below command also works fine from PowerShell cmd
Test-NetConnection -ComputerName watchdog.servicebus.windows.net -Port 9350

Error:

{
  "status": 400,
  "message": "Invalid Mashup Expression using supplied values.\r\n     inner exception: The key didn't match any rows in the table.\r\nclientRequestId: 3241abed-fdc7-4aa1-9555-3792ce5a3cb7",
  "source": "sql-logic-cp-southindia.logic-ase-southindia.p.azurewebsites.net"
}

Was this reply helpful? Yes No