(Nice!)īut it still doesn't work in the Service! What should we expect? I see this doc was also updated: it now lists Amazon Redshift as a connector that supports native database queries.
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).Īnd 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. pbix does not rely on the "native database query" feature. DirectQuery with Redshift works in the Power BI Service, if the. It says "DirectQuery (Power BI Desktop only)". I see the Amazon Redshift connector reference doc was updated last week - that is appreciated. (It did not work in Desktop before the October release!) But why isn't it working in the Service, with DirectQuery? This page (that you referenced) was last updated on I think it should be updated to reflect the new capabilities supported.Īnd this page was last updated on I think it should be updated to add Amazon Redshift to the list of connectors that support native database queries.Īnd native queries with Redshift do work in Power BI Desktop, now, with the October version only. The above sources seem to indicate that native queries with Redshift should be working now, with no limitations. Similar to SQL and Snowflake connectors, this will allow you to input an Amazon Redshift native query and build reports on top of it."
However, please refer to these two sources: