Forum Discussion

edsonfajilagot's avatar
edsonfajilagot
New Member
8 years ago

Error in accessing redshift spectrum (external table)

Hi guys,   Any success in getting data from redshift spectrum? I'm getting the error: DataSource.Error: The table has no visible columns and cannot be queried.   From aws documentation, https://d...
edsonfajilagot's avatar
edsonfajilagot
New Member
8 years ago

Hi v-huizhn-msft,

 

Thanks for you reply. I was able to connect and get the data from redshift to power bi (as mentioned in the blog). It works when my data source in redshift is a normal database table wherein data is loaded(physically).

 

It will not work when my datasource is an external table. External table in redshift does not contain data physically. The data is coming from an S3 file location.

 

 

Best Regards,

Edson

JF15's avatar
JF15
New Member
8 years ago

Hi,

 

we got the same issue. We cannot connect Power BI to redshift spectrum.

 

1) The connection to redshift itself works.

 

2) All "normal" redshift views and tables are working.

 

3) All spectrum tables (external tables) and views based upon those are not working.

 

I tried the POWER BI redshift connection as well as the redshift ODBC driver:

https://docs.aws.amazon.com/redshift/latest/mgmt/install-odbc-driver-windows.html

 

By the way - it works with Microsoft Excel. There you can access the spectrum tables.

 

Please support.

 

Kind regards,

 

Joern