Forum Discussion
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...
v-huizhn-msft
Microsoft Employee
Microsoft EmployeeHi edsonfajilagot,
In Power Bi desktop, please follow the steps in this official blog, and check if it works fine. And it also support for Amazon Redshift connectivity in the Power BI service.
Best Regards,
Angelia
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