In our firm, we are using Power BI to connect Redshift and SQL Server through import and Direct Query. We used to create SQL queries in Advanced option through power BI to connect with SQL Server. Th...
I'd request for two things to be fixed with this. 1. Advance query option so we can write custom queries. 2. Ability to set up direct query with a view on Redshift. Right now I only see an option to import all data from Redshift when using views on to PowerBI & then set up a refresh cycle. This is not going to help organizations that want to implement tool agnostic views. Many would be better served with ability to have a direct query to the Redshift views too.
