Forum Discussion

cmullins70's avatar
cmullins70
New Member
9 years ago

DataSource.Error: The table has no visible columns and cannot be queried. (Connecting to Segment)

I am attempting to pull in a new table from a Redshift Segment warehouse. I able able to connect to and pull from many tables, but some tables give this error:

 

DataSource.Error: The table has no visible columns and cannot be queried.

 

I have queried these tables from the command line and they are there and populated. 

 

How can I pull from these tables?

Need Help

2 Replies

  • v-qiuyu-msft's avatar
    v-qiuyu-msft
    Community Support
    9 years ago

    Hi cmullins70,

     

    Please check if any difference between those issued tables and other tables. Verify the data source credential set for the data source in desktop has sufficient permission to access the RedShift Segment warehouse.

     

    Best Regards,
    Qiuyun Yu

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    i dont know, why it happens . there may be different reason,  but in my case, my PowerBI was connected to a "View" which had "WITH NO SCHEMA binding" syntax in the end of SQL script (FYI : i was using Redshift DB). just take down syntax and try again. hope it helps.

    cheers 🙂