Forum Discussion

DarthTim's avatar
DarthTim
Frequent Visitor
4 years ago
Solved

Gateway Refresh error indicating missing column

I have a dashboard which is referencing redshift as the source.  It has been refreshing successfully through PBI desktop and publishing. However, we recently implemented a gateway and it is now unab...
Need Help
  • DarthTim's avatar
    DarthTim
    4 years ago

    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. 

DarthTim's avatar
DarthTim
Frequent Visitor
4 years ago

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.