Skip to main content

Power BI

Completed

Add AWS Redshift data source

Vote (266) Share
Michael Moore's profile image

Michael Moore on 11 Dec 2014 00:43:53

Administrator on 30 Jul 2016 07:39:48

Thanks everyone for your feedback – We have just released a new Amazon Redshift connector with the Power BI Desktop July Update! This connector is currently in Preview and it allows users to Import data or create a DirectQuery report based on Amazon Redshift data. In future releases, this connector will also be supported in Power BI Service and Gateway for Refresh purposes. Stay tuned! Please take a look at the Update Announcement blog (https://powerbi.microsoft.com/en-us/blog/power-bi-desktop-july-feature-summary/) and to this documentation article for more details: https://powerbi.microsoft.com/en-us/documentation/powerbi-desktop-connect-redshift/

Comments (75)
Michael Moore's profile image Profile Picture

6d1bd2ac badf-4b5b-b60b-58e1acb7f271 on 05 Jul 2020 23:17:09

RE: Add AWS Redshift data source

When will it be added to the gateway? This is needed to access Redshift instances in private subnets. That's where lots of instances reside because of security purposes.

Michael Moore's profile image Profile Picture

c3f9d3dc e145-489f-b19c-e5f0301144ac on 05 Jul 2020 23:02:40

RE: Add AWS Redshift data source

In the current set up, Redshift connection does not allow to flexibly write and edit SQL made queries.
Is this something on the roadmap?
I know that there is the ODBD way, but I would consider it a hack, rather than a fully stable solution.
Without SQL flexibility, the Redshift connector capabilities are largely diminished.

Michael Moore's profile image Profile Picture

b6e00bd4 0f67-49f9-b309-2ee4406124ab on 05 Jul 2020 22:53:17

RE: Add AWS Redshift data source

It's still Beta and I don't think it's SSL https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/19337296-redshift-encrypted-data-source-support

Michael Moore's profile image Profile Picture

031a8592 cfb7-47fc-86bf-b88eba4d56c8 on 05 Jul 2020 22:39:08

RE: Add AWS Redshift data source

When will it be supported in Power BI Service, and gateway for refresh?

Michael Moore's profile image Profile Picture

d93874c5 ac4c-ea11-a812-000d3a579c39 on 05 Jul 2020 22:38:34

RE: Add AWS Redshift data source

Is there any estimation on when this will be GA? I can not push this to replace Tableau as long as it is only in Beta.

Michael Moore's profile image Profile Picture

c25d2b23 9fb0-448d-b984-d6003dff609b on 05 Jul 2020 22:32:08

RE: Add AWS Redshift data source

Ah this is disappointing. I would love to use PowerBI. Great product from what I've seen and the price is extremely competitive. However, without Redshift support then it's dead in the water from my POV

Michael Moore's profile image Profile Picture

c1e9a1bc 8643-4f06-8752-78886cdad6c6 on 05 Jul 2020 22:32:04

RE: Add AWS Redshift data source

'@Miguel Llopis any update? Because we are choosing the BI Tool, and we already use AWS Redshift... So, that's a big issue for us, because we can't refresh our data in the cloud without a Gateway!
Do you have any ETA?
Tks!

Michael Moore's profile image Profile Picture

8fcfad3f 9175-4ffb-863f-5cb98f2d4b77 on 05 Jul 2020 22:31:56

RE: Add AWS Redshift data source

'@Miguel Llopis please update us on your comment that in which particular month, we would be able to use Amazon redshift gateway for refresh purpose. Thanks!

Michael Moore's profile image Profile Picture

71657e0f 6b6c-48b4-9691-123c9f7ea9a5 on 05 Jul 2020 22:30:45

RE: Add AWS Redshift data source

Agree with needing Redshift connectivity for PowerBI service for it to be a real contender. Otherwise this feels like a way to create migration pressure away from AWS to Azure to make PowerBI viable. Maybe I'll try QuickSight instead?

Michael Moore's profile image Profile Picture

a6b5e6e2 3ac9-4af3-8a46-fd879cfa6bd4 on 05 Jul 2020 22:28:06

RE: Add AWS Redshift data source

connector worked for me thanks, any idea when are you going to release this for PowerBI Service?