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. 

v-easonf-msft's avatar
v-easonf-msft
Community Support
4 years ago

Hi， DarthTim 

Have you tried publishing to a different workspace and reconfiguring the gateway?
If the problem persists, it is recommended to create a support ticket to let MS engineers look into the issue on your side.

 

Best Regards,
Community Support Team _ Eason

DarthTim's avatar
DarthTim
Frequent Visitor
4 years ago

No, I have not tried publishing to a different workspace. I will see if I can get access to another workspace. If I dont have any luck, I will try opening a ticket. Thank you.