Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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,
Solved! Go to 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
Proud to be a Super User!
Thank you for your time... do you know if this topic is in the backlog for future releases?
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
Proud to be a Super User!