Forum Discussion
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...
Hi Data_Suji ,
Please check the version of Power BI Desktop, If the version is not the latest, please update to the latest version.
Power BI October 2021 Feature Summary | Microsoft Power BI Blog | Microsoft Power BI
Best Regards,
Community Support Team_GaoIf 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
Advocate I
Advocate INote that this doesn't seem to be available in Power Query online for Dataflows. Yet.
HairyDrumrollAdvocate I
Advocate ICancel 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])