Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Be one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch now

kevhav

Native query for Amazon Redshift - not working in the Service

Submitted by Continued Contributor on ‎10-15-2021 01:26 PM

We found the new native query for Redshift feature works great, in the October version of Power BI Desktop. But after publishing the .pbix (in DirectQuery mode) to a workspace in the Power BI Service (in Premium Capacity), we get an error when trying to render the report in the Service. I contacted support, and they could only tell me: "it might take some time for this new feature to be available in your region." Is that right? ... Our region is 'West US (California)'.

They also referenced the Import data from a database using native database query page, and noted that Amazon Redshift is not listed there, yet. That doc will need an update, maybe.

 

Please help? Should we expect to wait for this to roll out to our region? How long could that take? Or, could this be some kind of bug?

Status: Accepted
See more ideas labeled with:
18 Comments (18 New)
Comments
v-chuncz-msft
Community Support
Community Support
‎10-29-2021 01:55 AM
Status changed to: Accepted
 
v-chuncz-msft
Community Support
Community Support
‎10-29-2021 02:00 AM

@kevhav 

 

A similar issue has been reported internally, so stay tuned. 

IcM 269226047

 

ScottBeal
Advocate I
Advocate I
‎10-29-2021 10:44 AM

Same issue here.

We have added native Redshift queries and set them to "Import".

 

They refresh correctly in Desktop but in the service, when refreshed, the error is:
 Processing error  Native queries aren't supported by this value.

nsu
Regular Visitor
‎12-10-2021 02:57 AM

I am having the same issue right there ... Hopefully there will be an correction asap.

modi123p
Helper III
Helper III
‎12-27-2021 12:45 AM

@hatim-stovewala 

For me .... Queries in native Mode work only in PBI Desktop for RedShift.

It does not work on PBI Service. It doesn't depend on type of SQL query.... it may be with or without Group By clause

 

Region: North Europe (Ireland)

 

Not sure why documentation states that it works.

 

If it works for anyone... can you please specify the region as well??

 

kevhav
Continued Contributor
Continued Contributor
‎01-04-2022 03:50 PM

This actually is working as expected for me now, in "West US (California)" region. Including if the query has a GROUP BY clause -- it still works.

 

Although some SQL syntax seems to break it, like putting a semicolon at the end of your SQL statement. So you might try a very simple SQL statement at first, to test if it works. Then add to it, to see if any type of SQL  syntax causes it to stop working.

Anonymous
Not applicable
‎04-25-2022 01:06 PM

Hello, 

Is there any update on this issue? A few of my colleagues and I are currently having this issue. 
Any insight would be greatly appreciated. 

 

Outschoorn
Regular Visitor
‎04-25-2022 03:57 PM

Hi, This issue was fixed in the Nov-2021 update to the power bi gateway.

Idea Statuses