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 ...
Since my original post, I have identified a solution. Apparently it is possible to query Redshift views if the "GRANT SELECT" permission is set for your user. For some reason this is not required when querying with other clients and visualization tools.
This does require that you create a view on your Redshift instance, naturally, but that is a fairly straightforward process. There are other advantages of using views as opposed to custom SQL statements for any type of database source. Chiefly, it enables query folding. For others, see Marco Russo's article: https://www.sqlbi.com/articles/data-import-best-practices-in-power-bi/