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

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.

lbendlin's avatar
lbendlin
Super User
4 years ago

you forgot to update the app.

  • DarthTim's avatar
    DarthTim
    Frequent Visitor
    4 years ago

    Are you referring to the PBIX file? I'm not sure what updates would be required. 

    • 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.