kevhav
Continued Contributor
4 years agoStatus:
Accepted
Native query for Amazon Redshift - not working in the Service
We found the new native query for Redshift feature works great, in the October version of Power BI Desktop. But after publishing the .pbix (in DirectQuery mode) to a workspace in the Power BI Service...
kevhav
Continued Contributor
4 years agov-chuncz-msft - thanks for your reply. I looked at that link, yes.
However, please refer to these two sources:
- This page, which says "Amazon Redshift connector support for native query" went into general availability on 2021-09-20.
- The October 2021 Feature Summary, which says "We are excited to announce support for native database queries for the Amazon Redshift connector. Similar to SQL and Snowflake connectors, this will allow you to input an Amazon Redshift native query and build reports on top of it."
The above sources seem to indicate that native queries with Redshift should be working now, with no limitations. Right?
This page (that you referenced) was last updated on 2021-09-17; I think it should be updated to reflect the new capabilities supported.
And this page was last updated on 2021-07-13; I think it should be updated to add Amazon Redshift to the list of connectors that support native database queries.
And native queries with Redshift do work in Power BI Desktop, now, with the October version only. (It did not work in Desktop before the October release!) But why isn't it working in the Service, with DirectQuery?