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...
v-huizhn-msft's avatar
v-huizhn-msft
Microsoft Employee
8 years ago

Hi 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

  • 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

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    I was able to import redshift spectrum tables in Power BI Desktop but when I use direct query mode I receive query folding errors. Any hint on how to resolve this issue?