Gateway connection to Sharepoint Survey error

[moomarine]

Hi All, I have a gateway setup to an "on premise" sharepoint site which has a survey list within. I have a dashboard that is connected successfully in PBI Desktop to the Survey and refreshes data fine. My issue is that the gateway connection is showing the error that it cant find various columns in the list. See photo attached. I cant seem to figure this out. My central IT help Desk sets up all our gateways so i cant get much info there.

[edejes2]

@moomarine , 

you are missing a column Q1 might be deleted check your table and make sure is there. 

Regards!

ED

[moomarine]

Hi again ED, i found how to post questions in the end haha!  That column is not missed from the table in sharepoint and it also refreshes fine in Power BI desktop just not via the gateway.