Refresh of Redshift data via Gateway: The table has no visible columns and cannot be queried.

[AndreeChristian]

We can pull all AWS-Redshift-tables with Power BI Desktop without any problems. Refreshing data in the Power BI Service via On Premise Gateway works for some tables, but leads to errors for other tables. It seems, that no schema information is available, e.g. "The table has no visible columns and cannot be queried." or "The column xxx of the table wasn't found.". The only difference in the table defintion we found is a different SORTKEY option (INTERLEAVED works, COMPOUND fails). Is there an known problem?

[AndreeChristian · Accepted solution]

Hi @GilbertQ ,

our problem is solved. We used a wrong user in the cloud which obviously has few rights than the desktop user. The error messages are confusing.

Thanks!

[GilbertQ]

Hi @AndreeChristian 

I have had data running from Redshift via the Gateway for a few months and I have never had any issues. I am not sure why this would be happening as some tables did have SORTKEY.

It sounds like the query is not working and I would look at the ODBC connection details?