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...
Nuria_Carol
Advocate I
Advocate IPlease add the option to do SQL queries in Redshift. For another case, we are using PowerBI with MySQL and the SQL query is working great. In Redshift, we also have millions of rows of data in each table, and we need to do complex SQL queries to get the data we need. It's not feasible to Import data. Using DirectQuery is not an option because we need to cross data from other data sources, and apart from that it does not allow us to do complex queries like we are doing in SQL. I cannot believe Microsoft has not though about that.
