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 ...
i am also having this issue.
it is very frustrating because i can find no way of querying redshift other than by connecting to an entire table. The problem with this is that when your table contains millions of records, the power bi desktop refresh becomes unworkable due to the time taken to download the data.
i really need a solution to be able to query subsets of data in redshift.