An error occurred on the server. Server Response: Not a valid connector Error response

[JJcPower99]

Hi, 

I keep receiving the same error when I try refresh and edit data within Power Apps. It was working fine before and today stopped working.  The error is below. If somebody could help.

Thanks

[sriniD]

Probably some gateway issue. Could please share sessionId of this repro.

[JJcPower99]

Hi,  @sriniD ! No problem! 

a9590a9f-e81c-4a0d-b35a-faf41427391b

This error also seems to only persist with this table.

Thanks 😊

[sriniD]

Thanks @JJcPower99 Unfortunately l didn't find any logs from the provided sessions. Seems to be there is popup blocker on the powerapps. Can you disable it and capture the session.

[JJcPower99]

Hi,  @sriniD appologies I'm having trouble disabling the blocker.

I've captured the below session. Thanks

Session ID: f851e68b-63f0-4a62-bff0-9bf29eb476dc

[sriniD]

THanks @JJcPower99 , will follow up SQL team.

[sriniD · Accepted solution]

@JJcPower99 Thanks for session. We figure out the issue, your backend sql table having sqlGeography type which doesn't support by PowerApps for which you are getting error.

Please see the PowerApps data mapping in Sql connector doc (https://docs.microsoft.com/en-us/connectors/sql/#powerapps-data-type-mappings) where we mentioned this limitation in the note:

“

If a SQL Server data type is not listed in the table above, it is not supported. Examples of unsupported SQL Server data types include: binary(), varbinary(), image, cursor, rowversion, hierarchyid, sql_variant xml, Spatial Geometry Types, Spatial Geography Types, and table.