Error "Native queries aren't supported by this value." using Redshift database

[Anonymous]

Hello everybody,

Please help me with this issue.

I´m using a simple "select" registered in advance options of de Amazon Redshift connection, and it works in Desktop Power BI version, but when I published the report in web it return this error message while refreshing the dataset: "Native queries aren't supported by this value."

I'm using Amazon Redshift database and don´t have any problems conecting to tables or views, however a simple select statement returns an error.

Let you the sentence, by the way, one of the sources is a view (left outer join)

I've changed de conection from Direct query to Import query, but the problem continues.

Thank you for your help.

Regards,

[Anonymous]

Thank you for your time... do you know if this topic is in the backlog for future releases?

[FarhanAhmed · Accepted solution]

Amazon Redshift is not supported in Schedule refresh in Power BI Report Server.

Power BI report data sources in Power BI Report Server - Power BI | Microsoft Docs