I am using the Amazon Redshift connector in Power BI. While I am able to connect to tables, I am not able to connect to views. I receieve the following error message:
DataSource.Error: The table has no visible columns and cannot be queried.
I have not had any difficulty connecting to this view using other client software. Likewise, I have not had any difficulty connecting Power BI to views on other database systems (such as Oracle). This seems to be a limitation in Power BI's connection to Amazon Redshift. In general I expect to be able to connect to a view the same way I connect to a table.