enterprise gateway mashup refresh error "the key didn't match any rows in the table"

[Anonymous]

Enterprise gateway refresh is failing after adding a new column to the sharepoint list it connects to. Desktop version refreshes without a problem and I have tried the suggested idea of modifying the query and republishing but still get the same issue. Also have rebuilt the report from scratch and still have the issue. Gateway connections test fine and it was working previously. 

[Conarl_on_BI · Accepted solution]

Do you have a SSO configured with the gateway? I would recommend downloading and updating the gateway with the May release at this link.
https://protect-us.mimecast.com/s/J0FGCPNGKYczRyDU0067Q?domain=powerbi.microsoft.com

This update version has new updates for data mashup.

[Conarl_on_BI · Accepted solution]

Do you have a SSO configured with the gateway? I would recommend downloading and updating the gateway with the May release at this link.
https://protect-us.mimecast.com/s/J0FGCPNGKYczRyDU0067Q?domain=powerbi.microsoft.com

This update version has new updates for data mashup.

[Anonymous · Accepted solution]

Yeah SSO. Will try again after we do the update. thanks