Native query for Amazon Redshift - not working in the Service
I see the Amazon Redshift connector reference doc was updated last week -- that is appreciated.
But, it's strange...
It says "DirectQuery (Power BI Desktop only)" ... but that is not completely true. DirectQuery with Redshift works in the Power BI Service, if the .pbix does not rely on the "native database query" feature. This has been the case for a long time.
It is true, currently, that when you are relying on the "native database query" feature, then DirectQuery does not work in the Power BI Service (but it does work in Power BI Desktop).
And it's also true that for a dataset in Import mode, which relies on the "native database query" feature, it cannot be refreshed in the Power BI Service.
I see this doc was also updated: it now lists Amazon Redshift as a connector that supports native database queries. (Nice!)
But it still doesn't work in the Service! What should we expect?
- Will Amazon Redshift with native query work in the Service, in Import mode (to refresh the dataset)? When?
- Will Amazon Redshift with native query work in the Service, in DirectQuery mode? When?
Amazon Redshift with native query + DirectQuery mode would be super-valuable to us! We've been waiting eagerly for this ... in fact, we've even been planning our development around it, assuming it was going to be available around September, 2021.
Because this page says "Native query support in the Amazon Redshift connector will enable users to build DirectQuery and import mode reports on top of a custom SQL query specified in the connection experience." And it says this has already gone into general availability.