topic Re: Error "Native queries aren't supported by this value." using Redshift database in Report Server

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

Anonymous — Fri, 06 May 2022 00:14:54 GMT

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,

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

FarhanAhmed — Fri, 06 May 2022 04:05:05 GMT

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

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

Anonymous — Fri, 06 May 2022 14:05:08 GMT

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