Forum Discussion
Gateway Refresh error indicating missing column
It looks like I have this figured out.
It seems the service account used for the gateway did not have access to the specific schema being referenced. So we assigned access and we are now able to refresh through the gateway.
So the error message we were receiving referring to a missing column was very misleading. I would have expected to get an access denied error message as opposed to a specific column missing.
So if you get a column not found message when going through a gateway, check if your access is setup correctly.
Every time you make substantial meta data changes in your dataset (or these changes are forced upon you by the data source) you need to re-publish the report to the workspace, and you may also need to also update the app.
I'm sorry, I'm not understanding.
Currently, to get this refreshed I'm refreshing from the data source using PBI desktop and republishing to the workspace. It works fine when I do that. But when I try and add this to the scheduling in the workspace using the gateway, is when I get these errors.
Thanks.