Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

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

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,