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 have since tried with ODBC which does work successfully, not tried large data volumes yet.
The only "problem" is that i now need to set up windows vm somewhere to host a data gateway, to allow it wto work on the Power BI Service