Skip to main content
Microsoft Idea

    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 (80)
    Michael Moore's profile image Profile Picture

    Alistair D on 05 Jul 2020 22:19:16

    RE: Add AWS Redshift data source

    '@jonathan, yes the odbc driver from AWS does 'work'... but it will load the entire table, it doesn't 'link' to a table and create a new sql statement as you explore the data - like Tableau does ;-) even good old MS Access can create an ODBC 'linked' table

    Michael Moore's profile image Profile Picture

    Faiz Vadakkumpadath on 05 Jul 2020 22:18:10

    RE: Add AWS Redshift data source

    Duplicate: https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/6826431-add-aws-redshift-data-source

    Michael Moore's profile image Profile Picture

    Faiz Vadakkumpadath on 05 Jul 2020 22:18:08

    RE: Add AWS Redshift data source

    Duplicate: https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/6826431-add-aws-redshift-data-source

    Michael Moore's profile image Profile Picture

    Power BI User on 05 Jul 2020 22:17:59

    RE: Add AWS Redshift data source

    Oui et cela m'évitera de benchmarker QuickSight

    Michael Moore's profile image Profile Picture

    Anonymous on 05 Jul 2020 22:17:58

    RE: Add AWS Redshift data source

    Yes please! Would use this daily.

    Michael Moore's profile image Profile Picture

    Dan Hookham 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

    Kristen Martel 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

    Power BI User 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

    Shawn on 05 Jul 2020 22:17:39

    RE: Add AWS Redshift data source

    https://youtu.be/AAAIL2hS4x4

    Michael Moore's profile image Profile Picture

    Jonathan Aisenberg 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

    Merged Idea (2)