Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now

Reply
Anonymous
Not applicable

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)

cmoscosoch_0-1651781715421.png

 

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

 

Thank you for your help.

Regards,

 

1 ACCEPTED SOLUTION
FarhanAhmed
Community Champion
Community Champion

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

 

FarhanAhmed_0-1651809885624.png

 

 

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







Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!

Proud to be a Super User!




View solution in original post

2 REPLIES 2
Anonymous
Not applicable

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

 

FarhanAhmed
Community Champion
Community Champion

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

 

FarhanAhmed_0-1651809885624.png

 

 

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







Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!

Proud to be a Super User!




Helpful resources

Announcements
OCT PBI Update Carousel

Power BI Monthly Update - October 2024

Check out the October 2024 Power BI update to learn about new features.

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

October NL Carousel

Fabric Community Update - October 2024

Find out what's new and trending in the Fabric Community.