Forum Discussion

Data_Suji's avatar
Data_Suji
Frequent Visitor
4 years ago
Solved

Connecting to Amazon Redshift data by writing a query.

Hi, I am trying to connect to Amazon Redshift data by writing a query to join multiple tables with conditions in Power BI. I understand that I can connect to tables and do a merge to achieve the same...
Need Help
Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hi Data_Suji ,

 

In Power BI Desktop, you can connect to an Amazon Redshift database and use the underlying data just like any other data source in Power BI Desktop. At the same time, in the advanced options, the SQL statement function is provided.

Attached document for reference.

Blog_1

Blog_2

 

Best Regards,
Community Support Team_Gao

 

If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly -- How to provide sample data

HairyDrumroll's avatar
HairyDrumroll
Advocate I
3 years ago

Note that this doesn't seem to be available in Power Query online for Dataflows. Yet.

  • HairyDrumroll's avatar
    HairyDrumroll
    Advocate I
    3 years ago

    Cancel that, works in Dataflows like this:

    Source = Value.NativeQuery(AmazonRedshift.Database("server.name.redshift.amazonaws.com","database_name"), "SELECT * FROM database_name.schema.view_or_table", null, [EnableFolding=true])