Load data from Power BI dataset into Redshift

[usrivastava]

Hi Forum members,

We have a requriement wherein we have to send a few columns' data from the Power BI dataset (which is built from various data sources) to AWS Redshift table and then merge this data to another important table to get the final sales reporting.

Can you please help me in understanding the solution that we can implement in our system to meet the above requirement most effectively. We came across a couple of names while searching for the solution - we can either use xmla endpoint or webhook. Any help here would be appreciated.

[lbendlin · Accepted solution]

Use Power Automate to run a DAX query against the dataset / semantic model and then push the result into Redshift.

Obligatory note:  Power BI is a downstream system.  You should connect Redshift to the actual data source.