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. 

lbendlin's avatar
lbendlin
Super User
4 years ago

I am referring to the workspace in the service (after you published the PBIX) and the app that needs updating

 

DarthTim's avatar
DarthTim
Frequent Visitor
4 years ago

Thanks. We dont have this published as an app. This is just published as a report. 

  • lbendlin's avatar
    lbendlin
    Super User
    4 years ago

    In that case I don't know what else to suggest.  Maybe republish the pbix.

    • DarthTim's avatar
      DarthTim
      Frequent Visitor
      4 years ago

      Thanks for your help. 

       

      • 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