cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
JJcPower99
Level: Powered On

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

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.

 

Screenshot (3).png

 

Thanks

1 ACCEPTED SOLUTION

Accepted Solutions
Power Apps Staff sriniD
Power Apps Staff

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

@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.

View solution in original post

6 REPLIES 6
Power Apps Staff sriniD
Power Apps Staff

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

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

JJcPower99
Level: Powered On

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

Hi,  @sriniD ! No problem! 

 

a9590a9f-e81c-4a0d-b35a-faf41427391b

 

This error also seems to only persist with this table.

 

Thanks 😊

Power Apps Staff sriniD
Power Apps Staff

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

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
Level: Powered On

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

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

I've captured the below session. Thanks

 

 

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

Power Apps Staff sriniD
Power Apps Staff

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

THanks @JJcPower99 , will follow up SQL team.

Power Apps Staff sriniD
Power Apps Staff

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

@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.

View solution in original post

Helpful resources

Announcements
New Ranks and Rank Icons in April

'New Ranks and Rank Icons in April

Read the announcement for more information!

Better Together’ Contest Finalists Announced!

'Better Together’ Contest Finalists Announced!

Congrats to the finalists of our ‘Better Together’-themed T-shirt design contest! Click for the top entries.

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

thirdimage

Community Summit North America

Innovate, Collaborate, Grow - The top training and networking event across the globe for Microsoft Business Applications

Top Solution Authors
Top Kudoed Authors
Users online (9,647)