Apply query to Redshift table before importing?

Hello, I am very excited about the new Redshift connector. However, we use Redshift to store big data that needs to have a query applied to it before bringing it in for analysis and visualization. It appears that the Redshift connection only allows you to bring in the entire table, and then apply a "Power Query" to it. Is there a way to apply a query to the original Redshift table before importing it to PowerBI? Thank you! -Alex