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

82c494a2 5be2-4f8a-9683-ebedde962492 on 05 Jul 2020 22:17:48

RE: Add AWS Redshift data source

This is a must. Not only is it a capability that strenghthens the PowerBI vs other tools conversation, but it also allows a stronger Azure vs AWS conversation because you can demonstrate the tools, gain buy in and then talk about how they could leverage other capabilities if they used Azure.

Michael Moore's profile image Profile Picture

2b769fd7 9654-47ee-a22f-72533af7baef on 05 Jul 2020 22:17:47

RE: Add AWS Redshift data source

and RDS ... connecting to db´s on AWS is an obvious way to take more market share and dramatically increase PBI user base

Michael Moore's profile image Profile Picture

c52bf488 7fc6-47bc-8c37-0342af84d2d4 on 05 Jul 2020 22:17:46

RE: Add AWS Redshift data source

This, or at very least a clear ODBC string connectivity guide would be very valuable in letting proponents of the PBI solution sell it to organizations invested in AWS.

Michael Moore's profile image Profile Picture

c0e6088b 021d-441e-84a1-d75c3818ee1b on 05 Jul 2020 22:17:39

RE: Add AWS Redshift data source

https://youtu.be/AAAIL2hS4x4

Michael Moore's profile image Profile Picture

5c3fb84f 9065-40fb-8b09-1227db152771 on 05 Jul 2020 22:17:24

RE: Add AWS Redshift data source

in the meantime, does this work? http://docs.aws.amazon.com/redshift/latest/mgmt/install-odbc-driver-windows.html

Michael Moore's profile image Profile Picture

feb52e32 4211-40d6-aa83-410bae410e6a on 05 Jul 2020 22:16:16

RE: Add AWS Redshift data source

This would move Power BI into contention with Tableau in a number of my current clients.

Michael Moore's profile image Profile Picture

a792c14d b61b-41c7-bea5-5da357d218f1 on 05 Jul 2020 22:16:15

RE: Add AWS Redshift data source

Hi Will,
yes, there are other users of redshift out there ;)

Pavel

Michael Moore's profile image Profile Picture

aca151dd 0b5f-4247-8325-ae5f632e3b1e on 05 Jul 2020 22:15:16

RE: Add AWS Redshift data source

Still waiting ....

Michael Moore's profile image Profile Picture

021030bb b63d-49e6-b046-5ecd7e74e333 on 05 Jul 2020 22:14:35

RE: Add AWS Redshift data source

'it seems far fetched that MS will support redshift but here is my
+1

Michael Moore's profile image Profile Picture

93baae98 462c-47e5-8029-8a4b297dc05f on 05 Jul 2020 22:14:10

RE: Add AWS Redshift data source

Any updates?