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

[cmullins70]

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?

[Anonymous]

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 🙂 

[v-qiuyu-msft]

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